diff options
| author | David Rowley <drowley@postgresql.org> | 2024-10-29 16:25:29 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2024-10-29 16:25:29 +1300 |
| commit | 75f09cc460a3a1780df1dcd102f46e59779f9903 (patch) | |
| tree | 7b0f1aa2f05ba344748550769cfb98c38fd7cfa1 | |
| parent | dfff687f3c25fd114a7ab7d22df645716a98139f (diff) | |
| download | postgresql-75f09cc460a3a1780df1dcd102f46e59779f9903.tar.gz postgresql-75f09cc460a3a1780df1dcd102f46e59779f9903.zip | |
Doc: clarify enable_indexscan=off also disabled Index Only Scans
Disabling enable_indexscan has always also disabled Index Only Scans.
Here we make that more clear in the documentation in an attempt to
prevent future complaints complaining about this expected behavior.
Reported-by: Melanie Plageman
Author: David G. Johnston, David Rowley
Backpatch-through: 12, oldest supported version
Discussion: https://postgr.es/m/CAAKRu_atV=kovgpaLREyG68PB5+ncKvJ2UNoeRetEgyC3Yb5Sw@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/config.sgml | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 9a479f28e07..49037fb4a97 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -5114,8 +5114,9 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class=" </term> <listitem> <para> - Enables or disables the query planner's use of index-scan plan - types. The default is <literal>on</literal>. + Enables or disables the query planner's use of index-scan and + index-only-scan plan types. The default is <literal>on</literal>. + Also see <xref linkend="guc-enable-indexonlyscan"/>. </para> </listitem> </varlistentry> @@ -5130,7 +5131,9 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class=" <para> Enables or disables the query planner's use of index-only-scan plan types (see <xref linkend="indexes-index-only-scans"/>). - The default is <literal>on</literal>. + The default is <literal>on</literal>. The + <xref linkend="guc-enable-indexscan"/> setting must also be + enabled to have the query planner consider index-only-scans. </para> </listitem> </varlistentry> |