Re: Index Scans become Seq Scans after VACUUM ANALYSE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index Scans become Seq Scans after VACUUM ANALYSE
Дата
Msg-id 11809.1019065544@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index Scans become Seq Scans after VACUUM ANALYSE  (mlw <markw@mohawksoft.com>)
Ответы Re: Index Scans become Seq Scans after VACUUM ANALYSE  (Sean Chittenden <sean@chittenden.org>)
Список pgsql-hackers
mlw <markw@mohawksoft.com> writes:
> ... I have seen many instances of when
> PostgreSQL refuses to use an index because the data distribution is uneven.

This is fixed, or at least attacked, in 7.2.  Again, I do not see this
as an argument for making the planner stupider instead of smarter.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Index Scans become Seq Scans after VACUUM ANALYSE
Следующее
От: mlw
Дата:
Сообщение: Re: Index Scans become Seq Scans after VACUUM ANALYSE