Re: Index Scans become Seq Scans after VACUUM ANALYSE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index Scans become Seq Scans after VACUUM ANALYSE
Дата
Msg-id 3171.1019015573@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index Scans become Seq Scans after VACUUM ANALYSE  (Michael Loftis <mloftis@wgops.com>)
Список pgsql-hackers
Michael Loftis <mloftis@wgops.com> writes:
> Reading all of this discussion lately about how the planner seems to 
> prefer seqscan's in alot of places where indexes would be better starts 
> making me wonder if some of the assumptions or cals made to figure costs 
> are wrong...

Could well be.  The sources are open, feel free to take a look ...
src/backend/optimizer/path/costsize.c is the epicenter ...
        regards, tom lane


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

Предыдущее
От: "Rod Taylor"
Дата:
Сообщение: Re: [BUGS] Foreign Key woes -- 7.2 and ~7.3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Index Scans become Seq Scans after VACUUM ANALYSE