Re: Simple postgresql.conf wizard

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Simple postgresql.conf wizard
Дата
Msg-id 28223.1226680995@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Simple postgresql.conf wizard  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Simple postgresql.conf wizard  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> You're right, I haven't, but yes I know that's a problem. We've chatted 
> about that with Greg sometimes. It would be nice to have more stable 
> plans. My favorite idea is to stop using the current relation size in 
> the planner, and use the value snapshotted at ANALYZE instead.

Sorry, that's a nonstarter.  We used to act that way and it was
completely fatal to plan quality in very many typical scenarios.

IMHO, the only thing worse than an unstable plan is a stable one.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CREATE AGGREGATE disallows STYPE = internal
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Simple postgresql.conf wizard