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