Re: Cached/global query plans, autopreparation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Cached/global query plans, autopreparation
Date
Msg-id 23312.1520023906@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cached/global query plans, autopreparation  (Andres Freund <andres@anarazel.de>)
Responses Re: Cached/global query plans, autopreparation
Re: Cached/global query plans, autopreparation
List 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 by date:

Previous
From: David Steele
Date:
Subject: Re: [HACKERS] Creating backup history files for backups taken fromstandbys
Next
From: Tomas Vondra
Date:
Subject: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions