Request a Demo
Home   >   mailing lists

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

From Osama Abdul Qader
Subject Re: Improving scalability of Parallel Bitmap Heap/Index Scan
Date
Msg-id CAC+8b5hLg08NG0EVUkpKkEUccP-8wH7F1F848h7Um6N5-aRfug@mail.gmail.com
Whole thread
In response to Re: Improving scalability of Parallel Bitmap Heap/Index Scan  (David Geier <geidav.pg@gmail.com>)
List pgsql-hackers
Tree view
Hi David, 

My name is Osama Abdul Qader, I'm interested to work with you, I'm a little busy with my chores right now and I'll review the patches that is attached to this email.

More information about me: linkedin.com/in/oa-qader

With regards.
Osama Abdul Qader

On Mon, 5 Oct, 2026, 2:23 pm David Geier, <geidav.pg@gmail.com> wrote:
Hi John,

> 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
> <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 <https://
> www.postgresql.org/message-id/attachment/120560/0007-Specialize-
> pagetable-sort-routines-in-tidbitmap.c.patch>

Thanks for the pointer. I've applied that change to my patch set. See
other mail. It helped a lot further reducing the sort time in each
parallel worker.

--
David Geier


pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Asynchronous MergeAppend
Next
From: Jakub Wartak
Date:
Subject: Re: amcheck: add index-all-keys-match verification for B-Tree