| From: | Cary Huang <cary(dot)huang(at)highgo(dot)ca> |
|---|---|
| To: | "Rafia Sabih" <rafia(dot)pghackers(at)gmail(dot)com> |
| Cc: | "Junwang Zhao" <zhjwpku(at)gmail(dot)com>, "David Rowley" <dgrowleyml(at)gmail(dot)com>, "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Support tid range scan in parallel? |
| Date: | 2025-06-05 21:24:25 |
| Message-ID: | 19741fb1e9a.d3a2d419725879.4749970543696365963@highgo.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello
Sorry David and all who have reviewed the patch, it's been awhile since the patch
was last worked on :(. Thank you all for the reviews and comments! Attached is
the rebased patch that adds support for parallel TID range scans. This feature is
particularly useful scanning large tables where the data needs to be scanned in
sizable segments using a TID range in the WHERE clause to define each segment.
By enabling parallelism, this approach can improve performance compared to
both non-parallel TID range scans and traditional sequential scans.
Regards
Cary Huang
| Attachment | Content-Type | Size |
|---|---|---|
| v5-0001-add-parallel-tid-rangescan.patch | application/octet-stream | 22.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias van de Meent | 2025-06-05 22:13:52 | Re: Non-reproducible AIO failure |
| Previous Message | David Rowley | 2025-06-05 21:23:03 | Re: Question Regarding Merge Append and Parallel Execution of Index Scans on Partitioned Table |