On Mon, Oct 5, 2026 at 3:53 PM David Geier <[email protected]> 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
