Re: Improving scalability of Parallel Bitmap Heap/Index Scan

From: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
To: David Geier <geidav(dot)pg(at)gmail(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Improving scalability of Parallel Bitmap Heap/Index Scan
Date: 2022-07-16 05:43:39
Message-ID: CAFBsxsHmwz5EahRGBdqWB67Jd009bfnsjfcch-hyE09x61XwxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 14, 2022 at 5:13 PM David Geier <geidav(dot)pg(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2022-07-16 06:58:10 Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)
Previous Message Thomas Munro 2022-07-16 05:18:25 Re: EINTR in ftruncate()