| From: | Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Limiting overshoot in nbtree's parallel SAOP index scans |
| Date: | 2025-05-07 21:31:27 |
| Message-ID: | CAEze2WhGmVWc6KBYgnE0Up=1eFr3_m2Enma1qhbs+wwzs3Xv5A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 11 Oct 2024 at 16:27, Matthias van de Meent <boekewurm(at)gmail(dot)com> wrote:
>
> Hi,
>
> With PG17's new SAOP handling the performance of certain index scans
> significantly improved performance in the serial case. However, for
> parallel index scans the performance picture is not as
> straightforward, and this has caused some issues earlier.
This is patch v2, now updated for HEAD to work with the newly added
skip scan changes, and some added polish.
Kind regards,
Matthias van de Meent
Neon (https://neon.tech)
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Avoid-full-parallel-btree-index-scans-in-skip-sca.patch | application/x-patch | 15.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2025-05-07 21:33:49 | Re: PG 18 release notes draft committed |
| Previous Message | Tom Lane | 2025-05-07 21:27:11 | Re: disabled SSL log_like tests |