=== Applying patches on top of PostgreSQL commit ID 05faf06e9c21f012355e7095435a5bfb013f5eec === /etc/rc.d/jail: WARNING: Per-jail configuration via jail_* variables is obsolete. Please consider migrating to /etc/jail.conf. === applying patch ./v9-0001-Introduce-RelInfoList-structure.patch patching file contrib/postgres_fdw/postgres_fdw.c Hunk #1 succeeded at 6079 (offset 10 lines). patching file src/backend/optimizer/geqo/geqo_eval.c patching file src/backend/optimizer/path/allpaths.c Hunk #1 succeeded at 3410 (offset 7 lines). patching file src/backend/optimizer/plan/planmain.c patching file src/backend/optimizer/util/relnode.c patching file src/include/nodes/pathnodes.h [cf/4881 6e689736e6] Introduce RelInfoList structure Author: Richard Guo Date: Tue Jun 11 15:59:19 2024 +0900 6 files changed, 133 insertions(+), 97 deletions(-) === applying patch ./v9-0002-Introduce-RelAggInfo-structure-to-store-info-for-grouped-paths.patch patching file src/backend/optimizer/util/relnode.c patching file src/include/nodes/pathnodes.h [cf/4881 c07b89de20] Introduce RelAggInfo structure to store info for grouped paths Author: Richard Guo Date: Tue Jun 11 16:01:26 2024 +0900 2 files changed, 118 insertions(+), 21 deletions(-) === applying patch ./v9-0003-Set-up-for-eager-aggregation-by-collecting-needed-infos.patch patching file src/backend/optimizer/path/allpaths.c patching file src/backend/optimizer/plan/initsplan.c patching file src/backend/optimizer/plan/planmain.c patching file src/backend/utils/misc/guc_tables.c Hunk #1 succeeded at 921 (offset -10 lines). patching file src/backend/utils/misc/postgresql.conf.sample patching file src/include/nodes/pathnodes.h patching file src/include/optimizer/paths.h patching file src/include/optimizer/planmain.h patching file src/test/regress/expected/sysviews.out Hunk #1 succeeded at 150 (offset 14 lines). Hunk #2 succeeded at 171 (offset 14 lines). [cf/4881 e3f80d871b] Set up for eager aggregation by collecting needed infos Author: Richard Guo Date: Tue Jun 11 16:03:00 2024 +0900 9 files changed, 315 insertions(+), 1 deletion(-) === applying patch ./v9-0004-Implement-functions-that-create-RelAggInfos-if-applicable.patch patching file src/backend/optimizer/path/equivclass.c patching file src/backend/optimizer/plan/initsplan.c patching file src/backend/optimizer/plan/planmain.c patching file src/backend/optimizer/util/relnode.c patching file src/backend/utils/adt/selfuncs.c patching file src/include/nodes/pathnodes.h patching file src/include/optimizer/pathnode.h patching file src/include/optimizer/paths.h [cf/4881 9dfead83fb] Implement functions that create RelAggInfos if applicable Author: Richard Guo Date: Tue Jun 11 16:04:41 2024 +0900 8 files changed, 704 insertions(+), 21 deletions(-) === applying patch ./v9-0005-Implement-functions-that-generate-paths-for-grouped-relations.patch patching file src/backend/optimizer/path/allpaths.c Hunk #3 succeeded at 3305 (offset 7 lines). patching file src/backend/optimizer/util/pathnode.c Hunk #1 succeeded at 2697 (offset -12 lines). Hunk #2 succeeded at 2949 (offset -12 lines). Hunk #3 succeeded at 2995 (offset -12 lines). Hunk #4 succeeded at 3153 (offset -12 lines). patching file src/include/optimizer/paths.h [cf/4881 71261867a6] Implement functions that generate paths for grouped relations Author: Richard Guo Date: Tue Jun 11 16:05:50 2024 +0900 3 files changed, 315 insertions(+), 8 deletions(-) === applying patch ./v9-0006-Build-grouped-relations-out-of-base-relations.patch patching file src/backend/optimizer/path/allpaths.c Hunk #6 succeeded at 1366 (offset 8 lines). patching file src/backend/optimizer/util/relnode.c patching file src/include/optimizer/pathnode.h [cf/4881 6379ad87a5] Build grouped relations out of base relations Author: Richard Guo Date: Tue Jun 11 16:07:32 2024 +0900 3 files changed, 196 insertions(+) === applying patch ./v9-0007-Build-grouped-relations-out-of-join-relations.patch patching file src/backend/optimizer/geqo/geqo_eval.c patching file src/backend/optimizer/path/allpaths.c Hunk #1 succeeded at 3861 (offset 7 lines). Hunk #2 succeeded at 3885 (offset 7 lines). Hunk #3 succeeded at 4774 (offset 7 lines). patching file src/backend/optimizer/path/joinrels.c Hunk #5 succeeded at 1805 (offset 3 lines). patching file src/backend/optimizer/plan/planner.c Hunk #4 succeeded at 6961 (offset -1 lines). Hunk #5 succeeded at 7108 (offset -1 lines). Hunk #6 succeeded at 7125 (offset -1 lines). Hunk #7 succeeded at 7133 (offset -1 lines). Hunk #8 succeeded at 7175 (offset -1 lines). Hunk #9 succeeded at 7235 (offset -1 lines). Hunk #10 succeeded at 7273 (offset -1 lines). Hunk #11 succeeded at 7302 (offset -1 lines). patching file src/backend/optimizer/util/appendinfo.c Hunk #1 succeeded at 499 (offset 4 lines). patching file src/backend/optimizer/util/relnode.c patching file src/include/nodes/pathnodes.h [cf/4881 457c58adc3] Build grouped relations out of join relations Author: Richard Guo Date: Tue Jun 11 16:08:23 2024 +0900 7 files changed, 385 insertions(+), 51 deletions(-) === applying patch ./v9-0008-Add-test-cases.patch patching file src/test/regress/expected/eager_aggregate.out patching file src/test/regress/parallel_schedule patching file src/test/regress/sql/eager_aggregate.sql [cf/4881 6d33b3a907] Add test cases Author: Richard Guo Date: Tue Jun 11 16:16:15 2024 +0900 3 files changed, 1486 insertions(+), 1 deletion(-) create mode 100644 src/test/regress/expected/eager_aggregate.out create mode 100644 src/test/regress/sql/eager_aggregate.sql === applying patch ./v9-0009-Add-README.patch patching file src/backend/optimizer/README [cf/4881 e103f55f74] Add README Author: Richard Guo Date: Tue Jun 11 16:17:27 2024 +0900 1 file changed, 88 insertions(+) === applying patch ./v9-0010-Run-pgindent.patch patching file src/backend/optimizer/geqo/geqo_eval.c patching file src/backend/optimizer/path/allpaths.c Hunk #2 succeeded at 1374 (offset 8 lines). Hunk #3 succeeded at 3426 (offset 7 lines). Hunk #4 succeeded at 3488 (offset 7 lines). Hunk #5 succeeded at 3534 (offset 7 lines). Hunk #6 succeeded at 3565 (offset 7 lines). Hunk #7 succeeded at 3612 (offset 7 lines). Hunk #8 succeeded at 3635 (offset 7 lines). Hunk #9 succeeded at 3648 (offset 7 lines). Hunk #10 succeeded at 3670 (offset 7 lines). Hunk #11 succeeded at 3683 (offset 7 lines). Hunk #12 succeeded at 3887 (offset 7 lines). Hunk #13 succeeded at 4784 (offset 7 lines). patching file src/backend/optimizer/path/joinrels.c patching file src/backend/optimizer/plan/initsplan.c patching file src/backend/optimizer/plan/planner.c Hunk #2 succeeded at 7244 (offset -1 lines). patching file src/backend/optimizer/util/appendinfo.c Hunk #1 succeeded at 546 (offset 4 lines). patching file src/backend/optimizer/util/relnode.c patching file src/include/nodes/pathnodes.h patching file src/tools/pgindent/typedefs.list Hunk #2 succeeded at 1061 (offset 2 lines). Hunk #3 succeeded at 2369 (offset 3 lines). [cf/4881 1552d60f50] Run pgindent Author: Richard Guo Date: Wed Jul 3 16:24:39 2024 +0900 9 files changed, 119 insertions(+), 111 deletions(-)