CLIENTS: 1 2025-12-06 20:09:48 -0500 CPU Governor info: Detected CPU Governor(s): performance 2025-12-06 20:09:48 -0500 postgres binary info for patch branch: "-rwxr-xr-x 1 pg pg 51M Dec 6 20:09 /mnt/nvme/postgresql/patch/install_meson_rc/bin/postgres" 2025-12-06 20:09:48 -0500 postgres git commits snippet for patch branch: commit a31f6e7c7550f91df4e53391b1aeaae99dfe4687 Author: Peter Geoghegan AuthorDate: 2025-12-06 20:09:26 -0500 Commit: Peter Geoghegan CommitDate: 2025-12-06 20:09:26 -0500 Revert "Use ignore_killed_tuples local variable" This reverts commit 19ec9bd82d6cd6369c3413e10234c17fd9973df4. diff --git a/src/backend/access/nbtree/nbtreadpage.c b/src/backend/access/nbtree/nbtreadpage.c index 7f9c66b8b..540d172cc 100644 --- a/src/backend/access/nbtree/nbtreadpage.c +++ b/src/backend/access/nbtree/nbtreadpage.c @@ -141,8 +141,7 @@ _bt_readpage(IndexScanDesc scan, ScanDirection dir, OffsetNumber offnum, OffsetNumber minoff; OffsetNumber maxoff; BTReadPageState pstate; - bool arrayKeys, - ignore_killed_tuples = scan->ignore_killed_tuples; + bool arrayKeys; int itemIndex, indnatts; @@ -247,7 +246,7 @@ _bt_readpage(IndexScanDesc scan, ScanDirection dir, OffsetNumber offnum, 2025-12-06 20:09:48 -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:09:48 -0500 postgres git commits snippet for master branch: commit f894acb24a12cf1f369a45af36c8f4049f9af571 Author: Nathan Bossart AuthorDate: 2025-12-02 11:29:45 -0500 Commit: Nathan Bossart 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 Reviewed-by: Robert Haas Reviewed-by: Chao Li 2025-12-06 20:09:48 -0500 - Skipping initial data load for run "patch.r1c1" because SKIP_INIT is true 2025-12-06 20:09:48 -0500 - prewarming tables for "patch.r1c1" 2025-12-06 20:09:49 -0500 - prewarming indexes for "patch.r1c1" 2025-12-06 20:09:49 -0500 - Start of pgbench run "patch.r1c1" pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.DoRYPLczEE -P 1 2025-12-06 20:14:49 -0500 - End of pgbench run "patch.r1c1" tps = 2824.368311, lat avg = 0.354 ms, lat stddev = 0.006 ms cpu/txn = 0.010716, cs/txn = 8.1149, in/txn = 0.1861 wrecs = 9, fpi = 4, wbytes = 17,854 wrecs/txn = 0.000, wbytes/txn = 0 2025-12-06 20:14:50 -0500 - Skipping initial data load for run "master.r1c1" because SKIP_INIT is true 2025-12-06 20:14:51 -0500 - prewarming tables for "master.r1c1" 2025-12-06 20:14:51 -0500 - prewarming indexes for "master.r1c1" 2025-12-06 20:14:51 -0500 - Start of pgbench run "master.r1c1" pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.DoRYPLczEE -P 1 2025-12-06 20:19:51 -0500 - End of pgbench run "master.r1c1" tps = 2709.501478, lat avg = 0.369 ms, lat stddev = 0.006 ms cpu/txn = 0.011183, cs/txn = 8.1160, in/txn = 0.1878 wrecs = 11, fpi = 4, wbytes = 26,418 wrecs/txn = 0.000, wbytes/txn = 0 tps ratio = ×1.042, lat ratio = ×0.959, wrecs ratio = ×0.818, fpi ratio = ×1.000, wbytes ratio = ×0.676 2025-12-06 20:19:53 -0500 - prewarming tables for "patch.r2c1" 2025-12-06 20:19:53 -0500 - prewarming indexes for "patch.r2c1" 2025-12-06 20:19:53 -0500 - Start of pgbench run "patch.r2c1" pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.DoRYPLczEE -P 1 2025-12-06 20:24:53 -0500 - End of pgbench run "patch.r2c1" tps = 2827.151192, lat avg = 0.354 ms, lat stddev = 0.006 ms cpu/txn = 0.010718, cs/txn = 8.1100, in/txn = 0.1794 wrecs = 9, fpi = 4, wbytes = 18,106 wrecs/txn = 0.000, wbytes/txn = 0 2025-12-06 20:24:55 -0500 - prewarming tables for "master.r2c1" 2025-12-06 20:24:55 -0500 - prewarming indexes for "master.r2c1" 2025-12-06 20:24:55 -0500 - Start of pgbench run "master.r2c1" pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.DoRYPLczEE -P 1 2025-12-06 20:29:55 -0500 - End of pgbench run "master.r2c1" tps = 2698.728180, lat avg = 0.370 ms, lat stddev = 0.006 ms cpu/txn = 0.011240, cs/txn = 8.1152, in/txn = 0.1892 wrecs = 11, fpi = 4, wbytes = 26,674 wrecs/txn = 0.000, wbytes/txn = 0 tps ratio = ×1.048, lat ratio = ×0.957, wrecs ratio = ×0.818, fpi ratio = ×1.000, wbytes ratio = ×0.679 2025-12-06 20:29:57 -0500 - prewarming tables for "patch.r3c1" 2025-12-06 20:29:57 -0500 - prewarming indexes for "patch.r3c1" 2025-12-06 20:29:57 -0500 - Start of pgbench run "patch.r3c1" pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.DoRYPLczEE -P 1 2025-12-06 20:34:57 -0500 - End of pgbench run "patch.r3c1" tps = 2827.090974, lat avg = 0.354 ms, lat stddev = 0.007 ms cpu/txn = 0.010718, cs/txn = 8.1122, in/txn = 0.1806 wrecs = 9, fpi = 4, wbytes = 18,358 wrecs/txn = 0.000, wbytes/txn = 0 2025-12-06 20:34:59 -0500 - prewarming tables for "master.r3c1" 2025-12-06 20:34:59 -0500 - prewarming indexes for "master.r3c1" 2025-12-06 20:35:00 -0500 - Start of pgbench run "master.r3c1" pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.DoRYPLczEE -P 1 2025-12-06 20:40:00 -0500 - End of pgbench run "master.r3c1" tps = 2702.281186, lat avg = 0.370 ms, lat stddev = 0.011 ms cpu/txn = 0.011213, cs/txn = 8.1180, in/txn = 0.1895 wrecs = 9, fpi = 4, wbytes = 26,786 wrecs/txn = 0.000, wbytes/txn = 0 tps ratio = ×1.046, lat ratio = ×0.957, wrecs ratio = ×1.000, fpi ratio = ×1.000, wbytes ratio = ×0.685 2025-12-06 20:40:01 -0500 - prewarming tables for "patch.r4c1" 2025-12-06 20:40:02 -0500 - prewarming indexes for "patch.r4c1" 2025-12-06 20:40:02 -0500 - Start of pgbench run "patch.r4c1" pgbench command: pgbench -s 100 -r -c 1 -j 32 -M "prepared" -T 300 -f /tmp/tmp.DoRYPLczEE -P 1