Message-ID: <f29565cb8b0cea781e6334c94c89d9b575a8023a.camel@cybertec.at>
Subject: Re: Querying one partition in a function takes locks on all
 partitions
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Renan Alves Fonseca <renanfonseca@gmail.com>, David Rowley
	 <dgrowleyml@gmail.com>
Cc: Evgeny Morozov <postgresql4@realityexists.net>, pgsql-general
	 <pgsql-general@postgresql.org>
Date: Mon, 31 Mar 2025 19:08:02 +0200
In-Reply-To: <CAN_p2QjXkBzyx55QAEGLfvWF0_UdusvxNmTykq_6jQsaaqjwTw@mail.gmail.com>
References: 
	<01020195b987abd3-a008b77d-8c63-4931-80a4-be36a351c8b2-000000@eu-west-1.amazonses.com>
	 <CAN_p2Qi_zie4aZqMcYuT-Y5CxyvUJ+nBAomQNJSPbBjrCPEXJw@mail.gmail.com>
	 <01020195dd9e8337-c912f36d-54ef-4d3c-a00d-5e697b308d33-000000@eu-west-1.amazonses.com>
	 <CAN_p2QghEHKeyTvb6Gc8F3y6wNm+dJXaCdrAnrV7TEq15Oh-pg@mail.gmail.com>
	 <CAApHDvp3EDrVhGjmb21bceJ5-Y7iXKOn2UGG3-ngp_9ob_mpLw@mail.gmail.com>
	 <CAN_p2QjXkBzyx55QAEGLfvWF0_UdusvxNmTykq_6jQsaaqjwTw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/f29565cb8b0cea781e6334c94c89d9b575a8023a.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-03-31 at 18:41 +0200, Renan Alves Fonseca wrote:
> I would add another Note below like:
> "Except when inlined, an SQL function is always executed with a
> generic plan. This behavior may not be desired in some situations, and
> it will be fixed in future versions."

But that is not true, as far as I can tell: just like any other prepared
statement, it may keep using custom plans.

Yours,
Laurenz Albe