Re: Improving scalability of Parallel Bitmap Heap/Index Scan

On Mon, Oct 5, 2026 at 3:53 PM David Geier <geidav(dot)pg(at)gmail(dot)com> wrote:
> > 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.

If that's the case, let's get that piece in committable shape first.
That will make sure PG20 gets some improvement regardless of what
happens with your other proposal, and allows us to isolate the effect
of the proposed architectural change.

--
John Naylor
Amazon Web Services