tableam: Perform CheckXidAlive check once per scan
Andres Freund <andres@anarazel.de>
tableam: Perform CheckXidAlive check once per scan Previously, the CheckXidAlive check was performed within the table_scan*next* functions. This caused the check to be executed for every fetched tuple, an unnecessary overhead. To fix, move the check to table_beginscan* so it is performed once per scan rather than once per row. Note: table_tuple_fetch_row_version() does not use a scan descriptor; therefore, the CheckXidAlive check is retained in that function. The overhead is unlikely to be relevant for the existing callers. Reported-by: Andres Freund <andres@anarazel.de> Author: Dilip Kumar <dilipbalaut@gmail.com> Suggested-by: Andres Freund <andres@anarazel.de> Suggested-by: Amit Kapila <akapila@postgresql.org> Reviewed-by: Andres Freund <andres@anarazel.de> Discussion: https://www.postgresql.org/message-id/tlpltqm5jjwj7mp66dtebwwhppe4ri36vdypux2zoczrc2i3mp%40dhv4v4nikyfg
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/heap/heapam.c | modified | +0 −10 |
| src/backend/access/index/genam.c | modified | +15 −15 |
| src/backend/access/table/tableam.c | modified | +6 −14 |
| src/include/access/tableam.h | modified | +36 −46 |
Discussion
- unnecessary executor overheads around seqscans 25 messages · 2026-01-23 → 2026-01-29