Re: generalizing the planner knobs

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: generalizing the planner knobs
Дата
Msg-id dmnc17$30b9$1@news.hub.org
обсуждение исходный текст
Ответ на generalizing the planner knobs  (Neil Conway <neilc@samurai.com>)
Ответы Re: generalizing the planner knobs  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-hackers
"Neil Conway" <neilc@samurai.com> wrote
>
> This would also be useful when diagnosing bad query plans: for example,
> setting enable_seqscan=false often causes the planner to disregard the
> use of *any* sequential scan, anywhere in the plan. The ability to
> slightly bump up the cost of particular operations would allow more
> alternative plans to be examined.
>

This method also has the problem of "enable_seqscan=false" in some 
situations. I would vote we implement the final general solution like query 
plan hints directly.

Regards,
Qingqing 




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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: [pgsql-www] Upcoming PG re-releases
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: [PATCHES] A couple of proposed pgbench changes