=== Applying patches on top of PostgreSQL commit ID 1fd1bd871012732e3c6c482667d2f2c56f1a9395 === /etc/rc.d/jail: WARNING: Per-jail configuration via jail_* variables is obsolete. Please consider migrating to /etc/jail.conf. Thu Feb 20 15:01:33 UTC 2025 On branch cf/4971 nothing to commit, working tree clean === applying patch ./v15-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch Applied patch to 'src/backend/commands/indexcmds.c' cleanly. Applied patch to 'src/backend/executor/execIndexing.c' cleanly. Applied patch to 'src/backend/executor/execPartition.c' cleanly. Applied patch to 'src/backend/executor/nodeModifyTable.c' cleanly. Applied patch to 'src/backend/optimizer/util/plancat.c' cleanly. Applied patch to 'src/backend/utils/time/snapmgr.c' cleanly. [cf/4971 11642c7f57] This is https://commitfest.postgresql.org/50/5160/ merged in single commit. it is required for stability of stress tests. Author: nkey Date: Tue Dec 31 14:09:52 2024 +0100 6 files changed, 216 insertions(+), 49 deletions(-) === applying patch ./v15-0002-Add-stress-tests-for-concurrent-index-operations.patch Applied patch to 'src/bin/pg_amcheck/meson.build' cleanly. Falling back to direct application... [cf/4971 db5a58aae5] Add stress tests for concurrent index operations Author: nkey Date: Sat Nov 30 16:24:20 2024 +0100 2 files changed, 190 insertions(+) create mode 100644 src/bin/pg_amcheck/t/006_cic.pl === applying patch ./v15-0003-Allow-advancing-xmin-during-non-unique-non-paral.patch Applied patch to 'contrib/amcheck/verify_nbtree.c' cleanly. Applied patch to 'contrib/pgstattuple/pgstattuple.c' cleanly. Applied patch to 'src/backend/access/brin/brin.c' cleanly. Applied patch to 'src/backend/access/gin/gininsert.c' cleanly. Applied patch to 'src/backend/access/gist/gistbuild.c' cleanly. Applied patch to 'src/backend/access/hash/hash.c' cleanly. Applied patch to 'src/backend/access/heap/heapam.c' cleanly. Applied patch to 'src/backend/access/heap/heapam_handler.c' cleanly. Applied patch to 'src/backend/access/index/genam.c' cleanly. Applied patch to 'src/backend/access/nbtree/nbtsort.c' cleanly. Applied patch to 'src/backend/access/spgist/spginsert.c' cleanly. Applied patch to 'src/backend/catalog/index.c' cleanly. Applied patch to 'src/backend/commands/indexcmds.c' cleanly. Applied patch to 'src/backend/optimizer/plan/planner.c' cleanly. Applied patch to 'src/include/access/heapam.h' cleanly. Applied patch to 'src/include/access/tableam.h' cleanly. Applied patch to 'src/test/modules/injection_points/Makefile' cleanly. Falling back to direct application... Applied patch to 'src/test/modules/injection_points/meson.build' cleanly. Falling back to direct application... [cf/4971 079ff06972] Allow advancing xmin during non-unique, non-parallel concurrent index builds by periodically resetting snapshots Author: nkey Date: Tue Dec 31 21:10:23 2024 +0100 20 files changed, 407 insertions(+), 34 deletions(-) create mode 100644 src/test/modules/injection_points/expected/cic_reset_snapshots.out create mode 100644 src/test/modules/injection_points/sql/cic_reset_snapshots.sql === applying patch ./v15-0004-Allow-snapshot-resets-during-parallel-concurrent.patch /work/patches/./v15-0004-Allow-snapshot-resets-during-parallel-concurrent.patch:306: indent with spaces. /* /work/patches/./v15-0004-Allow-snapshot-resets-during-parallel-concurrent.patch:311: indent with spaces. */ Applied patch to 'src/backend/access/brin/brin.c' cleanly. Applied patch to 'src/backend/access/heap/heapam_handler.c' cleanly. Applied patch to 'src/backend/access/nbtree/nbtsort.c' cleanly. Applied patch to 'src/backend/access/table/tableam.c' cleanly. Applied patch to 'src/backend/access/transam/parallel.c' cleanly. Applied patch to 'src/backend/catalog/index.c' cleanly. Applied patch to 'src/backend/executor/nodeSeqscan.c' cleanly. Applied patch to 'src/backend/utils/time/snapmgr.c' cleanly. Applied patch to 'src/include/access/parallel.h' cleanly. Applied patch to 'src/include/access/relscan.h' cleanly. Applied patch to 'src/include/access/tableam.h' cleanly. Applied patch to 'src/test/modules/injection_points/expected/cic_reset_snapshots.out' cleanly. Applied patch to 'src/test/modules/injection_points/sql/cic_reset_snapshots.sql' cleanly. warning: 2 lines add whitespace errors. [cf/4971 dcfe61cc5e] Allow snapshot resets during parallel concurrent index builds Author: nkey Date: Wed Jan 1 15:25:20 2025 +0100 13 files changed, 196 insertions(+), 67 deletions(-) === applying patch ./v15-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch /work/patches/./v15-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch:202: indent with spaces. /* /work/patches/./v15-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch:203: indent with spaces. * We need to ignore dead tuples for unique checks in case of concurrent build. /work/patches/./v15-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch:204: indent with spaces. * It is required because or periodic reset of snapshot. /work/patches/./v15-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch:205: indent with spaces. */ Applied patch to 'src/backend/access/heap/README.HOT' cleanly. Applied patch to 'src/backend/access/heap/heapam_handler.c' cleanly. Applied patch to 'src/backend/access/nbtree/nbtdedup.c' cleanly. Applied patch to 'src/backend/access/nbtree/nbtsort.c' cleanly. Applied patch to 'src/backend/access/nbtree/nbtsplitloc.c' cleanly. Applied patch to 'src/backend/access/nbtree/nbtutils.c' cleanly. Applied patch to 'src/backend/catalog/index.c' cleanly. Applied patch to 'src/backend/commands/indexcmds.c' cleanly. Applied patch to 'src/backend/utils/sort/tuplesortvariants.c' cleanly. Applied patch to 'src/include/access/nbtree.h' cleanly. Applied patch to 'src/include/access/tableam.h' cleanly. Applied patch to 'src/include/utils/tuplesort.h' cleanly. Applied patch to 'src/test/modules/injection_points/expected/cic_reset_snapshots.out' cleanly. warning: 4 lines add whitespace errors. [cf/4971 41e07baafb] Allow snapshot resets in concurrent unique index builds Author: nkey Date: Sat Dec 7 23:27:34 2024 +0100 13 files changed, 263 insertions(+), 93 deletions(-) === applying patch ./v15-0006-Add-STIR-Short-Term-Index-Replacement-access-met.patch Applied patch to 'contrib/pgstattuple/pgstattuple.c' cleanly. Applied patch to 'src/backend/access/Makefile' cleanly. Applied patch to 'src/backend/access/heap/vacuumlazy.c' cleanly. Applied patch to 'src/backend/access/meson.build' cleanly. Falling back to direct application... Falling back to direct application... Falling back to direct application... Applied patch to 'src/backend/catalog/index.c' cleanly. Applied patch to 'src/backend/commands/analyze.c' cleanly. Applied patch to 'src/backend/commands/vacuumparallel.c' cleanly. Applied patch to 'src/backend/nodes/makefuncs.c' cleanly. Applied patch to 'src/include/access/genam.h' cleanly. Applied patch to 'src/include/access/reloptions.h' cleanly. Falling back to direct application... Applied patch to 'src/include/catalog/pg_am.dat' cleanly. Applied patch to 'src/include/catalog/pg_opclass.dat' cleanly. Applied patch to 'src/include/catalog/pg_opfamily.dat' cleanly. Applied patch to 'src/include/catalog/pg_proc.dat' cleanly. Applied patch to 'src/include/nodes/execnodes.h' cleanly. Applied patch to 'src/include/utils/index_selfuncs.h' cleanly. Applied patch to 'src/test/regress/expected/amutils.out' cleanly. Applied patch to 'src/test/regress/expected/opr_sanity.out' cleanly. Applied patch to 'src/test/regress/expected/psql.out' cleanly. [cf/4971 6543319a2c] Add STIR (Short-Term Index Replacement) access method Author: nkey Date: Sat Dec 21 18:36:10 2024 +0100 23 files changed, 777 insertions(+), 18 deletions(-) create mode 100644 src/backend/access/stir/Makefile create mode 100644 src/backend/access/stir/meson.build create mode 100644 src/backend/access/stir/stir.c create mode 100644 src/include/access/stir.h === applying patch ./v15-0007-tuplestore-add-support-for-storing-Datum-values.patch Applied patch to 'src/backend/utils/sort/tuplestore.c' cleanly. Applied patch to 'src/include/utils/tuplestore.h' cleanly. [cf/4971 f78e138fe5] tuplestore: add support for storing Datum values Author: nkey Date: Sat Jan 25 13:33:21 2025 +0100 2 files changed, 239 insertions(+), 54 deletions(-) === applying patch ./v15-0008-Improve-CREATE-REINDEX-INDEX-CONCURRENTLY-using-.patch Applied patch to 'doc/src/sgml/monitoring.sgml' cleanly. Applied patch to 'doc/src/sgml/ref/create_index.sgml' cleanly. Applied patch to 'doc/src/sgml/ref/reindex.sgml' cleanly. Applied patch to 'src/backend/access/heap/README.HOT' cleanly. Applied patch to 'src/backend/access/heap/heapam_handler.c' cleanly. Applied patch to 'src/backend/catalog/index.c' cleanly. Applied patch to 'src/backend/catalog/system_views.sql' cleanly. Applied patch to 'src/backend/catalog/toasting.c' cleanly. Applied patch to 'src/backend/commands/indexcmds.c' cleanly. Applied patch to 'src/backend/nodes/makefuncs.c' cleanly. Applied patch to 'src/include/access/tableam.h' cleanly. Applied patch to 'src/include/catalog/index.h' cleanly. Applied patch to 'src/include/commands/progress.h' cleanly. Applied patch to 'src/include/nodes/execnodes.h' cleanly. Applied patch to 'src/include/nodes/makefuncs.h' cleanly. Applied patch to 'src/test/modules/injection_points/expected/cic_reset_snapshots.out' cleanly. Applied patch to 'src/test/modules/injection_points/sql/cic_reset_snapshots.sql' cleanly. Applied patch to 'src/test/regress/expected/create_index.out' cleanly. Applied patch to 'src/test/regress/expected/indexing.out' cleanly. Applied patch to 'src/test/regress/expected/rules.out' cleanly. Applied patch to 'src/test/regress/sql/create_index.sql' cleanly. [cf/4971 6cab5566f6] Improve CREATE/REINDEX INDEX CONCURRENTLY using auxiliary index Author: nkey Date: Tue Dec 31 15:03:10 2024 +0100 21 files changed, 1188 insertions(+), 397 deletions(-) === applying patch ./v15-0009-Concurrently-built-index-validation-uses-fresh-s.patch Applied patch to 'doc/src/sgml/ref/create_index.sgml' cleanly. Applied patch to 'doc/src/sgml/ref/reindex.sgml' cleanly. Applied patch to 'src/backend/access/heap/heapam_handler.c' cleanly. Applied patch to 'src/backend/access/nbtree/nbtsort.c' cleanly. Applied patch to 'src/backend/access/spgist/spgvacuum.c' cleanly. Applied patch to 'src/backend/catalog/index.c' cleanly. Applied patch to 'src/backend/commands/indexcmds.c' cleanly. Applied patch to 'src/include/access/transam.h' cleanly. [cf/4971 823edbb44a] Concurrently built index validation uses fresh snapshots Author: nkey Date: Sat Jan 25 17:21:29 2025 +0100 8 files changed, 97 insertions(+), 47 deletions(-) === applying patch ./v15-0010-Remove-PROC_IN_SAFE_IC-optimization.patch Applied patch to 'src/backend/access/brin/brin.c' cleanly. Applied patch to 'src/backend/access/nbtree/nbtsort.c' cleanly. Applied patch to 'src/backend/commands/indexcmds.c' cleanly. Applied patch to 'src/include/storage/proc.h' cleanly. Applied patch to 'src/test/modules/injection_points/Makefile' cleanly. Falling back to direct application... Applied patch to 'src/test/modules/injection_points/meson.build' cleanly. Falling back to direct application... [cf/4971 7c30ecaada] Remove PROC_IN_SAFE_IC optimization Author: nkey Date: Tue Dec 31 14:24:48 2024 +0100 8 files changed, 11 insertions(+), 233 deletions(-) delete mode 100644 src/test/modules/injection_points/expected/reindex_conc.out delete mode 100644 src/test/modules/injection_points/sql/reindex_conc.sql === applying patch ./v15-0011-Add-proper-handling-of-auxiliary-indexes-during-.patch Applied patch to 'doc/src/sgml/ref/create_index.sgml' cleanly. Applied patch to 'doc/src/sgml/ref/reindex.sgml' cleanly. Applied patch to 'src/backend/catalog/dependency.c' cleanly. Applied patch to 'src/backend/catalog/index.c' cleanly. Applied patch to 'src/backend/catalog/pg_depend.c' cleanly. Applied patch to 'src/backend/catalog/toasting.c' cleanly. Applied patch to 'src/backend/commands/indexcmds.c' cleanly. Applied patch to 'src/backend/commands/tablecmds.c' cleanly. Applied patch to 'src/include/catalog/dependency.h' cleanly. Applied patch to 'src/include/catalog/index.h' cleanly. Applied patch to 'src/test/regress/expected/create_index.out' cleanly. Applied patch to 'src/test/regress/sql/create_index.sql' cleanly. [cf/4971 a896fc73de] Add proper handling of auxiliary indexes during DROP/REINDEX operations Author: nkey Date: Tue Dec 31 14:36:31 2024 +0100 12 files changed, 362 insertions(+), 41 deletions(-) === applying patch ./v15-0012-Updates-index-insert-and-value-computation-logic.patch Applied patch to 'src/backend/catalog/index.c' cleanly. Applied patch to 'src/backend/executor/execIndexing.c' cleanly. [cf/4971 ebe5269cc9] Updates index insert and value computation logic to optimize auxiliary index handling. Author: nkey Date: Mon Dec 30 16:37:12 2024 +0100 2 files changed, 18 insertions(+), 4 deletions(-)