Re: PG 18 release notes draft committed

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: PG 18 release notes draft committed
Дата
Msg-id CAApHDvohfoJ0D9eiUuVyHU_kq2Y7A_jAjWVsUt0Fm7Gw1Q=1cQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG 18 release notes draft committed  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: PG 18 release notes draft committed
Список 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 по дате отправления: