Re: PG 18 release notes draft committed

On Mon, May 5, 2025 at 09:42:10PM +1200, David Rowley wrote:
> On Fri, 2 May 2025 at 16:01, Amit Langote <amitlangote09(at)gmail(dot)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.

Okay, I split them up and went with the attached patch.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Do not let urgent matters crowd out time for investment in the future.