Re: Improving scalability of Parallel Bitmap Heap/Index Scan - Mailing list pgsql-hackers

From John Naylor
Subject Re: Improving scalability of Parallel Bitmap Heap/Index Scan
Date
Msg-id CAFBsxsHmwz5EahRGBdqWB67Jd009bfnsjfcch-hyE09x61XwxA@mail.gmail.com
Whole thread Raw
In response to Improving scalability of Parallel Bitmap Heap/Index Scan  (David Geier <geidav.pg@gmail.com>)
List 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 by date:

Previous
From: Thomas Munro
Date:
Subject: Re: EINTR in ftruncate()
Next
From: Peter Eisentraut
Date:
Subject: Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)