Dominique Devienne <ddevienne@xxxxxxxxx> writes: > On Fri, Jan 21, 2022 at 5:47 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> There is a notion of "custom plans" in which parameter values are >> inserted as constants, precisely to allow simplifications based on >> known constant values. But this particular case isn't implemented. > Where can I read more about this? And is it something the client has > any influence on? Start here: https://www.postgresql.org/docs/current/sql-prepare.html https://www.postgresql.org/docs/current/plpgsql-implementation.html#PLPGSQL-PLAN-CACHING regards, tom lane
