NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitdda7816

committed

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 toprevent future complaints complaining about this expected behavior.Reported-by: Melanie PlagemanAuthor: David G. Johnston, David RowleyBackpatch-through: 12, oldest supported versionDiscussion:https://postgr.es/m/CAAKRu_atV=kovgpaLREyG68PB5+ncKvJ2UNoeRetEgyC3Yb5Sw@mail.gmail.com

1 parent49a2344 commitdda7816Copy full SHA for dda7816

File tree

1 file changed

-3

lines changed

doc/src/sgml
- config.sgml

1 file changed

-3

lines changed

`‎doc/src/sgml/config.sgml`

Lines changed: 6 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -5442,8 +5442,9 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="`
`5442`	`5442`	`</term>`
`5443`	`5443`	`<listitem>`
`5444`	`5444`	`<para>`
`5445`		`- Enables or disables the query planner's use of index-scan plan`
`5446`		`- types. The default is <literal>on</literal>.`
	`5445`	`+ Enables or disables the query planner's use of index-scan and`
	`5446`	`+ index-only-scan plan types. The default is <literal>on</literal>.`
	`5447`	`+ Also see <xref linkend="guc-enable-indexonlyscan"/>.`
`5447`	`5448`	`</para>`
`5448`	`5449`	`</listitem>`
`5449`	`5450`	`</varlistentry>`
`@@ -5458,7 +5459,9 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="`
`5458`	`5459`	`<para>`
`5459`	`5460`	`Enables or disables the query planner's use of index-only-scan plan`
`5460`	`5461`	`types (see <xref linkend="indexes-index-only-scans"/>).`
`5461`		`- The default is <literal>on</literal>.`
	`5462`	`+ The default is <literal>on</literal>. The`
	`5463`	`+ <xref linkend="guc-enable-indexscan"/> setting must also be`
	`5464`	`+ enabled to have the query planner consider index-only-scans.`
`5462`	`5465`	`</para>`
`5463`	`5466`	`</listitem>`
`5464`	`5467`	`</varlistentry>`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitdda7816

File tree

1 file changed

1 file changed

`‎doc/src/sgml/config.sgml`

0 commit comments