Dissapearing indexes, what's that all about?

Поиск
Список
Период
Сортировка
От Daniel ?erud
Тема Dissapearing indexes, what's that all about?
Дата
Msg-id 986140786.134zilch@home.se
обсуждение исходный текст
Список pgsql-general
Hey people,
have a very strange problem now...
It's that when my database with the script i'm using a
explain select * from acc where username='britta' yields an
index scan. Very nice. But after some time being up the
same thing yields a SEQUENTIAL scan. What's happening
folks? =) No more than update's select's and vacuums has
been invoked.

Thanks! *hug*

Daniel Åkerud


В списке pgsql-general по дате отправления: