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 по дате отправления:

Предыдущее
От: Alexander Lohse
Дата:
Сообщение: Using Indices
Следующее
От: "Len Morgan"
Дата:
Сообщение: Re: Dissapearing indexes, what's that all about?