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