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

Commit82e79ee

Browse files
committed
Add doc entry for the new GUC paramenter enable_group_by_reordering
0452b46 adds alternative orderings of group-by keys during the queryoptimization. This new feature is controlled by the new GUC parameterenable_group_by_reordering, which accidentally came without the documentation.This commit adds the missing documentation for that GUC.Reported-by: Bruce MomjianDiscussion:https://postgr.es/m/ZnDx2FYlba_OafQd%40momjian.usAuthor: Andrei LepikhovReviewed-by: Pavel Borisov, Alexander Korotkov
1 parentfd49e8f commit82e79ee

File tree

1 file changed

+19
-0
lines changed

1 file changed

+19
-0
lines changed

‎doc/src/sgml/config.sgml‎

Lines changed: 19 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -5341,6 +5341,25 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
53415341
</listitem>
53425342
</varlistentry>
53435343

5344+
<varlistentry id="guc-enable-groupby-reordering" xreflabel="enable_group_by_reordering">
5345+
<term><varname>enable_group_by_reordering</varname> (<type>boolean</type>)
5346+
<indexterm>
5347+
<primary><varname>enable_group_by_reordering</varname> configuration parameter</primary>
5348+
</indexterm>
5349+
</term>
5350+
<listitem>
5351+
<para>
5352+
Controls if the query planner will produce a plan which will provide
5353+
<literal>GROUP BY</literal> keys sorted in the order of keys of
5354+
a child node of the plan, such as an index scan. When disabled, the
5355+
query planner will produce a plan with <literal>GROUP BY</literal>
5356+
keys only sorted to match the <literal>ORDER BY</literal> clause,
5357+
if any. When enabled, the planner will try to produce a more
5358+
efficient plan. The default value is <literal>on</literal>.
5359+
</para>
5360+
</listitem>
5361+
</varlistentry>
5362+
53445363
<varlistentry id="guc-enable-hashagg" xreflabel="enable_hashagg">
53455364
<term><varname>enable_hashagg</varname> (<type>boolean</type>)
53465365
<indexterm>

0 commit comments

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