Re: force the use of a particular index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: force the use of a particular index
Дата
Msg-id 12043.1057938267@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: force the use of a particular index  (Scott Cain <cain@cshl.org>)
Список pgsql-performance
Scott Cain <cain@cshl.org> writes:
> Embarrassingly, I can't.  I've been monkeying with the database so much
> that I can't seem to get it back to the state where I reproduce the
> behavior I want.

If the thing works as desired after a VACUUM ANALYZE, then I suggest
the estimation failure was just due to out-of-date statistics ...

            regards, tom lane

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

Предыдущее
От: Scott Cain
Дата:
Сообщение: Re: force the use of a particular index
Следующее
От: "Nikolaus Dilger"
Дата:
Сообщение: Re: Dual Xeon + HW RAID question