Re: Improving scalability of Parallel Bitmap Heap/Index Scan

Поиск
Список
Период
Сортировка
От John Naylor
Тема Re: Improving scalability of Parallel Bitmap Heap/Index Scan
Дата
Msg-id CAFBsxsHmwz5EahRGBdqWB67Jd009bfnsjfcch-hyE09x61XwxA@mail.gmail.com
обсуждение исходный текст
Ответ на Improving scalability of Parallel Bitmap Heap/Index Scan  (David Geier <geidav.pg@gmail.com>)
Список pgsql-hackers
On Thu, Jul 14, 2022 at 5:13 PM David Geier <geidav.pg@gmail.com> wrote:
> optimizing the PagetableEntry data structure for size and using a faster sorting algorithm like e.g. radix sort

On this note, there has been a proposed (but as far as I know untested) patch to speed up this sort in a much simpler way, in this thread

https://www.postgresql.org/message-id/CA%2BhUKGKztHEWm676csTFjYzortziWmOcf8HDss2Zr0muZ2xfEg%40mail.gmail.com

where you may find this patch

https://www.postgresql.org/message-id/attachment/120560/0007-Specialize-pagetable-sort-routines-in-tidbitmap.c.patch

and see if it helps.

--
John Naylor
EDB: http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления: