On Mon, May 5, 2025 at 09:42:10PM +1200, David Rowley wrote:
> 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.
Okay, I split them up and went with the attached patch.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
