Hi, I find that the postgresql.conf.sample file doesn't contain enable_self_join_elimination guc. If this is necessary, please see the attached patch.
-- Thanks, Tender Wang
From f27c99aebbd07d4008173492c7913749b149b540 Mon Sep 17 00:00:00 2001 From: Tender Wang <tndrw...@gmail.com> Date: Sun, 6 Apr 2025 11:54:49 +0800 Subject: [PATCH] Put enable_self_join_elimination into postgresql.conf.sample --- src/backend/utils/misc/postgresql.conf.sample | 1 + 1 file changed, 1 insertion(+) diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index ff56a1f0732..bcd4e67f43e 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -427,6 +427,7 @@ #enable_tidscan = on #enable_group_by_reordering = on #enable_distinct_reordering = on +#enable_self_join_elimination = on # - Planner Cost Constants - -- 2.34.1
