Re: Add mention in docs about locking all partitions for generic plans - Mailing list pgsql-hackers

From David Rowley
Subject Re: Add mention in docs about locking all partitions for generic plans
Date
Msg-id CAApHDvogvzANoTOCyXUWgEuPFx1nT6S63aAN0bDRSJ=TaGBWew@mail.gmail.com
Whole thread Raw
In response to Re: Add mention in docs about locking all partitions for generic plans  (Tender Wang <tndrwang@gmail.com>)
Responses Re: Add mention in docs about locking all partitions for generic plans
List pgsql-hackers
On Mon, 24 Mar 2025 at 22:19, Tender Wang <tndrwang@gmail.com> wrote:
>> Maybe I was wrong about writing nothing in master's docs. It might
>> still be important to detail this. I don't know the best way to phrase
>> that, but maybe something along the lines of: "The query planner
>> obtains locks for all partitions which are part of the plan.  However,
>> when the executor uses a cached plan, locks are only obtained on the
>> partitions which remain after partition pruning done during the
>> initialization phase of execution, i.e., the ones shown in the EXPLAIN
>> output and not the ones referred to by the “Subplans Removed”
>> property.".
>>
>> Any opinions?
>
> The above sentence looks good to me.

Thanks for looking.

I've attached the master and the <= v17 in patch form. Also, the
compiled HTML for ease of review.

I'll push these in the next few days unless anyone else wants to voice
their opinions.

David

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: AIO v2.5
Next
From: Andres Freund
Date:
Subject: Re: AIO v2.5