Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit717d0e8

Browse files
committed
Remove GUC_NOT_IN_SAMPLE from enable_self_join_elimination
fc069a3 implements Self-Join Elimination (SJE) and provides a new GUCvariable: enable_self_join_elimination. This new GUC variable was markedas GUC_NOT_IN_SAMPLE. However, enable_self_join_elimination is documentedand is not different from any other enable_* GUCs. Thus, removeGUC_NOT_IN_SAMPLE from it and add it to the postgresql.conf.sample.Discussion:https://postgr.es/m/CAPpHfdsqMTEsmxk3aQwt6xPz%2BKpUELO%3D6fzmER9ZRGrbs4uMfA%40mail.gmail.comAuthor: Tender Wang <tndrwang@gmail.com>Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
1 parentae60947 commit717d0e8

File tree

2 files changed

+2
-1
lines changed

2 files changed

+2
-1
lines changed

‎src/backend/utils/misc/guc_tables.c‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -998,7 +998,7 @@ struct config_bool ConfigureNamesBool[] =
998998
{"enable_self_join_elimination",PGC_USERSET,QUERY_TUNING_METHOD,
999999
gettext_noop("Enables removal of unique self-joins."),
10001000
NULL,
1001-
GUC_EXPLAIN |GUC_NOT_IN_SAMPLE
1001+
GUC_EXPLAIN
10021002
},
10031003
&enable_self_join_elimination,
10041004
true,

‎src/backend/utils/misc/postgresql.conf.sample‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -427,6 +427,7 @@
427427
#enable_tidscan = on
428428
#enable_group_by_reordering = on
429429
#enable_distinct_reordering = on
430+
#enable_self_join_elimination = on
430431

431432
# - Planner Cost Constants -
432433

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp