public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: David Rowley <[email protected]>
Cc: Melanie Plageman <[email protected]>
Cc: Pg Hackers <[email protected]>
Cc: Robert Haas <[email protected]>
Subject: Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on
Date: Mon, 21 Oct 2024 19:40:11 -0700
Message-ID: <CAKFQuwaC6E02tnDKFzf4CWhpjJYAv4XfZoMuBn_a07QnYeRb1Q@mail.gmail.com> (raw)
In-Reply-To: <CAApHDvr_Ncavgr7z4xmXuStWCaQoE0=z2kZj6JiFku8DB1iBfw@mail.gmail.com>
References: <CAAKRu_atV=kovgpaLREyG68PB5+ncKvJ2UNoeRetEgyC3Yb5Sw@mail.gmail.com>
<CAApHDvqAY6OVVPSRqGkcPExRKutCGzZPbhWm0EkORWGqLBWVxQ@mail.gmail.com>
<CAKFQuwYx0m2O3rM=CF1nj6xuqNMTe-NPNOsue7chyqS_EjhKng@mail.gmail.com>
<CAApHDvr_Ncavgr7z4xmXuStWCaQoE0=z2kZj6JiFku8DB1iBfw@mail.gmail.com>
On Monday, October 21, 2024, David Rowley <[email protected]> wrote:
> On Tue, 22 Oct 2024 at 14:46, David G. Johnston
> <[email protected]> wrote:
> > We should probably at least improve the documentation in 19.17.1; this
> interaction is apparently not self-evident.
> >
> > enable_indexscan
> >
> > Enable or disable the planner’s use of both index-scan and
> index-only-scans plan types.
> >
> > enabled_indexonlyscan
> >
> > Set to off to disable index-only-scan plan type while leaving index-scan
> plan types enabled. This setting has no effect if enable_indexscan is set
> to off.
>
> Yeah, I agree. The documentation could better reflect the current
> behaviour.
>
> Do you want to submit that in patch form?
>
Will do tomorrow.
David J.
view thread (10+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on
In-Reply-To: <CAKFQuwaC6E02tnDKFzf4CWhpjJYAv4XfZoMuBn_a07QnYeRb1Q@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox