Re: Cached/global query plans, autopreparation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cached/global query plans, autopreparation
Дата
Msg-id 23312.1520023906@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Cached/global query plans, autopreparation  (Andres Freund <andres@anarazel.de>)
Ответы Re: Cached/global query plans, autopreparation  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Cached/global query plans, autopreparation  (Jim Finnerty <jfinnert@amazon.com>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2018-03-02 15:29:09 -0500, Bruce Momjian wrote:
>> While I have heard people complain about how other databases cache
>> prepare plans, I have heard few complaints about the Postgres approach,
>> and I haven't even heard of people asking to control the documented "five
>> or more" behavior.

> This *constantly* is a problem.

Yeah, I've certainly heard complaints about it.  I do agree with
Bruce's conclusion that we should try to improve that behavior;
but it's not entirely clear how.  (A user-frobbable knob isn't
necessarily the best answer.)

            regards, tom lane


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

Предыдущее
От: David Steele
Дата:
Сообщение: Re: [HACKERS] Creating backup history files for backups taken fromstandbys
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions