Re: Improving scalability of Parallel Bitmap Heap/Index Scan

From: Osama Abdul Qader <osamaabdulqader(dot)cs(at)gmail(dot)com>
To: David Geier <geidav(dot)pg(at)gmail(dot)com>
Cc: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Improving scalability of Parallel Bitmap Heap/Index Scan
Date: 2026-10-05 09:11:14
Message-ID: CAC+8b5hLg08NG0EVUkpKkEUccP-8wH7F1F848h7Um6N5-aRfug@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(dot)pg(at)gmail(dot)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
>
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jakub Wartak 2026-10-05 09:18:41 Re: amcheck: add index-all-keys-match verification for B-Tree
Previous Message Etsuro Fujita 2026-10-05 09:10:35 Re: Asynchronous MergeAppend