v1-plus-ignore_killed_tuples-change.out
application/octet-stream
Filename: v1-plus-ignore_killed_tuples-change.out
Type: application/octet-stream
Part: 1
CLIENTS: 1
2025-12-06 20:41:23 -0500 CPU Governor info:
Detected CPU Governor(s): performance
2025-12-06 20:41:23 -0500 postgres binary info for patch branch:
"-rwxr-xr-x 1 pg pg 51M Dec 6 20:40 /mnt/nvme/postgresql/patch/install_meson_rc/bin/postgres"
2025-12-06 20:41:23 -0500 postgres git commits snippet for patch branch:
commit 19ec9bd82d6cd6369c3413e10234c17fd9973df4
Author: Peter Geoghegan <pg@bowt.ie>
AuthorDate: 2025-12-06 16:28:19 -0500
Commit: Peter Geoghegan <pg@bowt.ie>
CommitDate: 2025-12-06 20:07:44 -0500
Use ignore_killed_tuples local variable
diff --git a/src/backend/access/nbtree/nbtreadpage.c b/src/backend/access/nbtree/nbtreadpage.c
index 540d172cc..7f9c66b8b 100644
--- a/src/backend/access/nbtree/nbtreadpage.c
+++ b/src/backend/access/nbtree/nbtreadpage.c
@@ -141,7 +141,8 @@ _bt_readpage(IndexScanDesc scan, ScanDirection dir, OffsetNumber offnum,
OffsetNumber minoff;
OffsetNumber maxoff;
BTReadPageState pstate;
- bool arrayKeys;
+ bool arrayKeys,
+ ignore_killed_tuples = scan->ignore_killed_tuples;
int itemIndex,
indnatts;
@@ -246,7 +247,7 @@ _bt_readpage(IndexScanDesc scan, ScanDirection dir, OffsetNumber offnum,
* If the scan specifies not to return killed tuples, then we
* treat a killed tuple as not passing the qual
2025-12-06 20:41:23 -0500 postgres binary info for master branch:
"-rwxr-xr-x 1 pg pg 51M Dec 2 19:18 /mnt/nvme/postgresql/master/install_meson_rc/bin/postgres"
2025-12-06 20:41:23 -0500 postgres git commits snippet for master branch:
commit f894acb24a12cf1f369a45af36c8f4049f9af571
Author: Nathan Bossart <nathan@postgresql.org>
AuthorDate: 2025-12-02 11:29:45 -0500
Commit: Nathan Bossart <nathan@postgresql.org>
CommitDate: 2025-12-02 11:29:45 -0500
Show size of DSAs and dshashes in pg_dsm_registry_allocations.
Presently, this view reports NULL for the size of DSAs and dshash
tables because 1) the current backend might not be attached to them
and 2) the registry doesn't save the pointers to the dsa_area or
dshash_table in local memory. Also, the view doesn't show
partially-initialized entries to avoid ambiguity, since those
entries would report a NULL size as well.
This commit introduces a function that looks up the size of a DSA
given its handle (transiently attaching to the control segment if
needed) and teaches pg_dsm_registry_allocations to use it to show
the size of successfully-initialized DSA and dshash entries.
Furthermore, the view now reports partially-initialized entries
with a NULL size.
Reviewed-by: Rahila Syed <rahilasyed90@gmail.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
2025-12-06 20:41:23 -0500 - Skipping initial data load for run "patch.r1c1" because SKIP_INIT is true
2025-12-06 20:41:23 -0500 - prewarming tables for "patch.r1c1"
2025-12-06 20:41:24 -0500 - prewarming indexes for "patch.r1c1"
2025-12-06 20:41:24 -0500 - Start of pgbench run "patch.r1c1"
pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.fstRY2w5TY -P 1
2025-12-06 20:46:24 -0500 - End of pgbench run "patch.r1c1"
tps = 2845.974549, lat avg = 0.351 ms, lat stddev = 0.006 ms
cpu/txn = 0.010658, cs/txn = 8.1118, in/txn = 0.1826
wrecs = 9, fpi = 2, wbytes = 11,132
wrecs/txn = 0.000, wbytes/txn = 0
2025-12-06 20:46:25 -0500 - Skipping initial data load for run "master.r1c1" because SKIP_INIT is true
2025-12-06 20:46:26 -0500 - prewarming tables for "master.r1c1"
2025-12-06 20:46:26 -0500 - prewarming indexes for "master.r1c1"
2025-12-06 20:46:26 -0500 - Start of pgbench run "master.r1c1"
pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.fstRY2w5TY -P 1
2025-12-06 20:51:26 -0500 - End of pgbench run "master.r1c1"
tps = 2692.648534, lat avg = 0.371 ms, lat stddev = 0.006 ms
cpu/txn = 0.011253, cs/txn = 8.1122, in/txn = 0.1841
wrecs = 11, fpi = 4, wbytes = 27,186
wrecs/txn = 0.000, wbytes/txn = 0
tps ratio = ×1.057, lat ratio = ×0.946, wrecs ratio = ×0.818, fpi ratio = ×0.500, wbytes ratio = ×0.409
2025-12-06 20:51:28 -0500 - prewarming tables for "patch.r2c1"
2025-12-06 20:51:28 -0500 - prewarming indexes for "patch.r2c1"
2025-12-06 20:51:28 -0500 - Start of pgbench run "patch.r2c1"
pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.fstRY2w5TY -P 1
2025-12-06 20:56:28 -0500 - End of pgbench run "patch.r2c1"
tps = 2859.588502, lat avg = 0.350 ms, lat stddev = 0.011 ms
cpu/txn = 0.010596, cs/txn = 8.1058, in/txn = 0.1740
wrecs = 11, fpi = 4, wbytes = 19,258
wrecs/txn = 0.000, wbytes/txn = 0
2025-12-06 20:56:30 -0500 - prewarming tables for "master.r2c1"
2025-12-06 20:56:30 -0500 - prewarming indexes for "master.r2c1"
2025-12-06 20:56:30 -0500 - Start of pgbench run "master.r2c1"
pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.fstRY2w5TY -P 1
2025-12-06 21:01:30 -0500 - End of pgbench run "master.r2c1"
tps = 2697.135338, lat avg = 0.371 ms, lat stddev = 0.006 ms
cpu/txn = 0.011259, cs/txn = 8.1124, in/txn = 0.1838
wrecs = 9, fpi = 4, wbytes = 27,298
wrecs/txn = 0.000, wbytes/txn = 0
tps ratio = ×1.060, lat ratio = ×0.943, wrecs ratio = ×1.222, fpi ratio = ×1.000, wbytes ratio = ×0.705
2025-12-06 21:01:32 -0500 - prewarming tables for "patch.r3c1"
2025-12-06 21:01:32 -0500 - prewarming indexes for "patch.r3c1"
2025-12-06 21:01:32 -0500 - Start of pgbench run "patch.r3c1"
pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.fstRY2w5TY -P 1
2025-12-06 21:06:33 -0500 - End of pgbench run "patch.r3c1"
tps = 2849.075604, lat avg = 0.351 ms, lat stddev = 0.011 ms
cpu/txn = 0.010635, cs/txn = 8.1067, in/txn = 0.1762
wrecs = 9, fpi = 4, wbytes = 19,366
wrecs/txn = 0.000, wbytes/txn = 0
2025-12-06 21:06:34 -0500 - prewarming tables for "master.r3c1"
2025-12-06 21:06:35 -0500 - prewarming indexes for "master.r3c1"
2025-12-06 21:06:35 -0500 - Start of pgbench run "master.r3c1"
pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.fstRY2w5TY -P 1
2025-12-06 21:11:35 -0500 - End of pgbench run "master.r3c1"
tps = 2704.200739, lat avg = 0.370 ms, lat stddev = 0.006 ms
cpu/txn = 0.011217, cs/txn = 8.1108, in/txn = 0.1830
wrecs = 10, fpi = 4, wbytes = 27,648
wrecs/txn = 0.000, wbytes/txn = 0
tps ratio = ×1.054, lat ratio = ×0.949, wrecs ratio = ×0.900, fpi ratio = ×1.000, wbytes ratio = ×0.700
2025-12-06 21:11:36 -0500 - prewarming tables for "patch.r4c1"
2025-12-06 21:11:37 -0500 - prewarming indexes for "patch.r4c1"
2025-12-06 21:11:37 -0500 - Start of pgbench run "patch.r4c1"
pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.fstRY2w5TY -P 1