From dda781609f977315c9ecdefc1e29f9499393aaa4 Mon Sep 17 00:00:00 2001
From: David Rowley
Date: Tue, 29 Oct 2024 16:24:10 +1300
Subject: 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
---
doc/src/sgml/config.sgml | 9 ++++++---
1 file changed, 6 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index dc401087dc6..d54f9049569 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -5442,8 +5442,9 @@ ANY num_sync ( .
@@ -5458,7 +5459,9 @@ ANY num_sync ( ).
- The default is on.
+ The default is on. The
+ setting must also be
+ enabled to have the query planner consider index-only-scans.
--
cgit v1.2.3