Re: Support tid range scan in parallel?

Cary Huang <cary.huang@highgo.ca>

From: Cary Huang <cary.huang@highgo.ca>

To: "Rafia Sabih" <rafia.pghackers@gmail.com>

Cc: "Junwang Zhao" <zhjwpku@gmail.com>, "David Rowley" <dgrowleyml@gmail.com>, "Pgsql Hackers" <pgsql-hackers@postgresql.org>

Date: 2025-06-05T21:24:25Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix possibly uninitialized HeapScanDesc.rs_startblock
- d167c19295da 19 (unreleased) landed
Add parallelism support for TID Range Scans
- 0ca3b16973a8 19 (unreleased) landed
Avoid repeating loads of frozen ID values.
- dd0183469bb7 17.0 cited

Attachments

v5-0001-add-parallel-tid-rangescan.patch (application/octet-stream)

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