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

Appearance settings

Commit 82e79ee

Browse filesBrowse files
committed
Add doc entry for the new GUC paramenter enable_group_by_reordering
0452b46 adds alternative orderings of group-by keys during the query optimization. This new feature is controlled by the new GUC parameter enable_group_by_reordering, which accidentally came without the documentation. This commit adds the missing documentation for that GUC. Reported-by: Bruce Momjian Discussion: https://postgr.es/m/ZnDx2FYlba_OafQd%40momjian.us Author: Andrei Lepikhov Reviewed-by: Pavel Borisov, Alexander Korotkov
1 parent fd49e8f commit 82e79ee
Copy full SHA for 82e79ee

File tree

Expand file treeCollapse file tree

1 file changed

+19
-0
lines changed
Filter options
Expand file treeCollapse file tree

1 file changed

+19
-0
lines changed

‎doc/src/sgml/config.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/config.sgml
+19Lines 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 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.