=== Applying patches on top of PostgreSQL commit ID d5622acb32b3c11a27b323138fbee9c715742b38 === /etc/rc.d/jail: WARNING: Per-jail configuration via jail_* variables is obsolete. Please consider migrating to /etc/jail.conf. === applying patch ./v2-0001-Use-specialized-sort-facilities.patch patching file contrib/intarray/_int.h patching file contrib/intarray/_int_gist.c patching file contrib/intarray/_int_op.c patching file contrib/intarray/_int_tool.c patching file src/include/port.h patching file src/port/qsort.c [cf/5036 069a5ab96f] Use specialized sort facilities Author: Andrey M. Borodin Date: Sun Sep 8 15:43:39 2024 +0700 6 files changed, 47 insertions(+), 35 deletions(-) === applying patch ./v2-0002-Optimized-Oid-List-Sorting-by-using-template-sort.patch patching file src/backend/nodes/list.c patching file src/include/nodes/pg_list.h [cf/5036 50d81a9fff] Optimized Oid List Sorting by using template sorting algorithm Author: Stepan Neretin Date: Sun Sep 8 15:43:52 2024 +0700 2 files changed, 15 insertions(+) === applying patch ./v2-0003-Enhanced-Sorting-Efficiency-for-Oid-Lists.patch patching file src/backend/catalog/heap.c patching file src/backend/catalog/pg_publication.c patching file src/backend/utils/cache/relcache.c [cf/5036 afd8accb99] Enhanced Sorting Efficiency for Oid Lists Author: Stepan Neretin Date: Sun Sep 8 15:43:56 2024 +0700 3 files changed, 4 insertions(+), 4 deletions(-) === applying patch ./v2-0004-Optimized-Integer-List-Sorting-by-Using-Template-.patch patching file src/backend/nodes/list.c patching file src/include/nodes/pg_list.h [cf/5036 278884f4f6] Optimized Integer List Sorting by Using Template Sorting Algorithm Author: Stepan Neretin Date: Sun Sep 8 15:44:00 2024 +0700 2 files changed, 15 insertions(+) === applying patch ./v2-0005-Refactor-Grouping-Sets-Sorting-to-Use-list_int_so.patch patching file src/backend/parser/parse_agg.c Hunk #1 succeeded at 1959 (offset 89 lines). [cf/5036 636b7d5772] Refactor Grouping Sets Sorting to Use list_int_sort Author: Stepan Neretin Date: Sun Sep 8 15:44:04 2024 +0700 1 file changed, 1 insertion(+), 1 deletion(-) === applying patch ./v2-0006-Optimize-int16-Array-Sorting-in-CreateStatistics.patch patching file src/backend/commands/statscmds.c [cf/5036 5218b7b3b9] Optimize int16 Array Sorting in CreateStatistics Author: Stepan Neretin Date: Sun Sep 8 15:44:07 2024 +0700 1 file changed, 8 insertions(+), 1 deletion(-) === applying patch ./v2-0007-Introduce-a-sorting-template-for-float8-arrays-in.patch patching file src/backend/utils/adt/geo_spgist.c [cf/5036 4e9ea6eaa1] Introduce a sorting template for float8 arrays in geo_spgist.c to boost performance. Author: Stepan Neretin Date: Sun Sep 8 15:44:10 2024 +0700 1 file changed, 11 insertions(+) === applying patch ./v2-0008-Replace-qsort-calls-with-the-new-sorting-template.patch patching file src/backend/utils/adt/geo_spgist.c [cf/5036 8deff9d5e8] Replace qsort calls with the new sorting template `sort_float8_arr` for better performance in spg_box_quad_picksplit function. Author: Stepan Neretin Date: Sun Sep 8 15:44:13 2024 +0700 1 file changed, 4 insertions(+), 4 deletions(-) === applying patch ./v2-0009-Add-extenstion-to-bench-perfomance-improvements.patch patching file contrib/bench_sort_improvements/Makefile patching file contrib/bench_sort_improvements/bench.c patching file contrib/bench_sort_improvements/bench_sort_improvements--1.0.sql patching file contrib/bench_sort_improvements/bench_sort_improvements.control [cf/5036 542b4e797d] Add extenstion to bench perfomance improvements. Author: Stepan Neretin Date: Sun Sep 8 15:44:19 2024 +0700 4 files changed, 262 insertions(+) create mode 100644 contrib/bench_sort_improvements/Makefile create mode 100644 contrib/bench_sort_improvements/bench.c create mode 100644 contrib/bench_sort_improvements/bench_sort_improvements--1.0.sql create mode 100644 contrib/bench_sort_improvements/bench_sort_improvements.control === applying patch ./v2-0010-Refactor-LSN-Sorting-to-Use-Template-Based-sort_c.patch patching file src/backend/replication/syncrep.c [cf/5036 9e10aed7ae] Refactor LSN Sorting to Use Template-Based sort_cmp_lsn Author: Stepan Neretin Date: Sun Sep 8 15:44:22 2024 +0700 1 file changed, 13 insertions(+), 16 deletions(-)