| From: | David Geier <geidav(dot)pg(at)gmail(dot)com> |
|---|---|
| To: | John Naylor <john(dot)naylor(at)enterprisedb(dot)com>, 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: | 2026-10-05 08:53:30 |
| Message-ID: | 5498c845-8872-4092-8e8c-7ce6e3b75f5a@googlemail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nisha Moond | 2026-10-05 08:57:16 | Re: Fix apply worker crash when subscriber table has only a deferrable primary key |
| Previous Message | David Geier | 2026-10-05 08:51:51 | Re: Improving scalability of Parallel Bitmap Heap/Index Scan |