Re: PG 18 release notes draft committed - Mailing list pgsql-hackers

From David Rowley
Subject Re: PG 18 release notes draft committed
Date
Msg-id CAApHDvohfoJ0D9eiUuVyHU_kq2Y7A_jAjWVsUt0Fm7Gw1Q=1cQ@mail.gmail.com
Whole thread Raw
In response to Re: PG 18 release notes draft committed  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: PG 18 release notes draft committed
List pgsql-hackers
On Fri, 2 May 2025 at 16:01, Amit Langote <amitlangote09@gmail.com> wrote:
> +Allow partitions to be pruned earlier and quicker, and skipped in
> more places (Amit Langote, Ashutosh Bapat, Yuya Watari, David Rowley)
>
> Alternatively, 2 and 3 can be combined as:

> 2. Speed up partition planning by improving EquivalenceClass lookups
> (Yuya Watari, David Rowley, Ashutosh Bapat)

> Any thoughts, David?

I agree that 88f55bc97 and d69d45a5a should be in their own item.
Likely no need to go into detail about the speed up being about
"EquivalenceClass lookups". I imagine something like "Reduce planner
overheads when planning queries to partitioned and inheritance parent
tables"

Then for bb3ec16e1, d47cbf474, cbc127917 and 525392d57, something like
"Defer locking of partitions during execution until after partition
elimination".  The release notes for 11.0 called it "partition
elimination", so I went with that naming.

David



pgsql-hackers by date:

Previous
From: Nazir Bilal Yavuz
Date:
Subject: Re: Fix a race condition in ConditionVariableTimedSleep()
Next
From: Nisha Moond
Date:
Subject: Re: Fix slot synchronization with two_phase decoding enabled