MIME-Version: 1.0
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>
In-Reply-To: <CAApHDvr_Ncavgr7z4xmXuStWCaQoE0=z2kZj6JiFku8DB1iBfw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 22 Oct 2024 17:50:56 -0700
Message-ID: <CAKFQuwbNOj4f6ar1+jkBFGhK+t6fNwzM0ygLh7GBFSxVGSO8TQ@mail.gmail.com>
Subject: Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on
To: David Rowley <dgrowleyml@gmail.com>
Cc: Melanie Plageman <melanieplageman@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>, 
	Robert Haas <robertmhaas@gmail.com>
Content-Type: multipart/mixed; boundary="00000000000079e52106251a4900"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbNOj4f6ar1%2BjkBFGhK%2Bt6fNwzM0ygLh7GBFSxVGSO8TQ%40mail.gmail.com>
Precedence: bulk

--00000000000079e52106251a4900
Content-Type: multipart/alternative; boundary="00000000000079e51f06251a49fe"

--00000000000079e51f06251a49fe
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Oct 21, 2024 at 7:20=E2=80=AFPM David Rowley <dgrowleyml@gmail.com>=
 wrote:

> On Tue, 22 Oct 2024 at 14:46, David G. Johnston
> <david.g.johnston@gmail.com> wrote:
> > We should probably at least improve the documentation in 19.17.1; this
> interaction is apparently not self-evident.
>
> Yeah, I agree. The documentation could better reflect the current
> behaviour.
>
> Do you want to submit that in patch form?
>
>
Went with a slightly different wording that seems to flow better with the
xrefs I added between the two options.

David J.

--00000000000079e51f06251a49fe
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Oct 21, 2024 at 7:20=E2=80=AFPM David Rowley &lt;<=
a href=3D"mailto:dgrowleyml@gmail.com">dgrowleyml@gmail.com</a>&gt; wrote:<=
/span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex">On Tue, 22 Oct 2024 at 14:46, David G. Johnston<br>
&lt;<a href=3D"mailto:david.g.johnston@gmail.com" target=3D"_blank">david.g=
.johnston@gmail.com</a>&gt; wrote:<br>
&gt; We should probably at least improve the documentation in 19.17.1; this=
 interaction is apparently not self-evident.<br><br>
Yeah, I agree. The documentation could better reflect the current behaviour=
.<br>
<br>
Do you want to submit that in patch form?<br><br></blockquote><div><br></di=
v><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-se=
rif">Went with a slightly different wording that seems to flow better with =
the xrefs I added between the two options.</div><div class=3D"gmail_default=
" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"=
gmail_default" style=3D"font-family:arial,helvetica,sans-serif">David J.</d=
iv><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-s=
erif"><br></div></div></div>

--00000000000079e51f06251a49fe--
--00000000000079e52106251a4900
Content-Type: text/x-patch; charset="US-ASCII"; 
	name="v1-0001-doc-Cross-reference-enable_indexscan-and-enable_inde.patch"
Content-Disposition: attachment; 
	filename="v1-0001-doc-Cross-reference-enable_indexscan-and-enable_inde.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_m2l5qbms0>
X-Attachment-Id: f_m2l5qbms0

RnJvbSA4YjliZTQwOTYzNTIwODhlYTIyZjExNGU2ODA0MWZkMDllZTZlMjhjIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiAiRGF2aWQgRy4gSm9obnN0b24iIDxEYXZpZC5HLkpvaG5zdG9u
QEdtYWlsLmNvbT4KRGF0ZTogVHVlLCAyMiBPY3QgMjAyNCAxNzoyNToyNyAtMDcwMApTdWJqZWN0
OiBbUEFUQ0hdIGRvYzogQ3Jvc3MgcmVmZXJlbmNlIGVuYWJsZV9pbmRleHNjYW4gYW5kCiBlbmFi
bGVfaW5kZXhvbmx5c2NhbgoKRG9jdW1lbnQgdGhhdCBlbmFibGVfaW5kZXhzY2FuIGNvbnRyb2xz
IHRoZSBpbmNsdXNpb24gb2YgYWxsIChub3JtYWwKYW5kIGluZGV4LW9ubHkpIGluZGV4IHNjYW4g
cGxhbiBub2RlIHR5cGVzLiAgTm90ZSB0aGF0IGluZGV4LW9ubHkgc2NhbnMKY2FuIGJlIGluZGVw
ZW5kZW50bHkgZGlzYWJsZWQuCgpOb3RlIHRoZSBpbXBsaWNhdGlvbiBvZiB0aGlzIGluIGVuYWJs
ZV9pbmRleG9ubHlzY2FuLCB0aGF0IGEgc2V0dGluZyBvZgoib24iIGlzIGlnbm9yZWQgd2hlbiBh
bGwgaW5kZXggc2NhbnMgdHlwZXMgYXJlIGRpc2FibGVkLgoKTGVmdCB1bndyaXR0ZW4gaXMgdGhl
IGFic2VuY2Ugb2YgYSBzeW1tZXRyaWMgb3B0aW9uIHRvIGV4Y2x1ZGUgbm9ybWFsCmluZGV4IHNj
YW5zIHdoaWxlIGFsbG93aW5nIGluZGV4LW9ubHkgc2NhbnMuCi0tLQogZG9jL3NyYy9zZ21sL2Nv
bmZpZy5zZ21sIHwgMTEgKysrKysrKy0tLS0KIDEgZmlsZSBjaGFuZ2VkLCA3IGluc2VydGlvbnMo
KyksIDQgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21s
IGIvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCmluZGV4IDkzNGVmNWU0NjkuLjA0Y2JlN2FjMzQg
MTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9jb25maWcuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwv
Y29uZmlnLnNnbWwKQEAgLTU0MTUsOCArNTQxNSwxMCBAQCBBTlkgPHJlcGxhY2VhYmxlIGNsYXNz
PSJwYXJhbWV0ZXIiPm51bV9zeW5jPC9yZXBsYWNlYWJsZT4gKCA8cmVwbGFjZWFibGUgY2xhc3M9
IgogICAgICAgPC90ZXJtPgogICAgICAgPGxpc3RpdGVtPgogICAgICAgIDxwYXJhPgotICAgICAg
ICBFbmFibGVzIG9yIGRpc2FibGVzIHRoZSBxdWVyeSBwbGFubmVyJ3MgdXNlIG9mIGluZGV4LXNj
YW4gcGxhbgotICAgICAgICB0eXBlcy4gVGhlIGRlZmF1bHQgaXMgPGxpdGVyYWw+b248L2xpdGVy
YWw+LgorICAgICAgICBFbmFibGVzIG9yIGRpc2FibGVzIHRoZSBxdWVyeSBwbGFubmVyJ3MgdXNl
IG9mIGFsbCBpbmRleC1zY2FuIHJlbGF0ZWQgcGxhbgorICAgICAgICB0eXBlcy4gVGhlIGRlZmF1
bHQgaXMgPGxpdGVyYWw+b248L2xpdGVyYWw+LiBUaGUgaW5kZXgtb25seS1zY2FuIHBsYW4gdHlw
ZXMKKyAgICAgICAgY2FuIGJlIGluZGVwZW5kZW50bHkgZGlzYWJsZWQgYnkgc2V0dGluZyA8eHJl
ZiBsaW5rZW5kPSJndWMtZW5hYmxlLWluZGV4b25seXNjYW4iLz4KKyAgICAgICAgdG8gPGxpdGVy
YWw+b2ZmPC9saXRlcmFsPi4KICAgICAgICA8L3BhcmE+CiAgICAgICA8L2xpc3RpdGVtPgogICAg
ICA8L3Zhcmxpc3RlbnRyeT4KQEAgLTU0MjksOSArNTQzMSwxMCBAQCBBTlkgPHJlcGxhY2VhYmxl
IGNsYXNzPSJwYXJhbWV0ZXIiPm51bV9zeW5jPC9yZXBsYWNlYWJsZT4gKCA8cmVwbGFjZWFibGUg
Y2xhc3M9IgogICAgICAgPC90ZXJtPgogICAgICAgPGxpc3RpdGVtPgogICAgICAgIDxwYXJhPgot
ICAgICAgICBFbmFibGVzIG9yIGRpc2FibGVzIHRoZSBxdWVyeSBwbGFubmVyJ3MgdXNlIG9mIGlu
ZGV4LW9ubHktc2NhbiBwbGFuCisgICAgICAgIFNldCB0byA8bGl0ZXJhbD5vZmY8L2xpdGVyYWw+
IHRvIGRpc2FibGUgdGhlIHF1ZXJ5IHBsYW5uZXIncyB1c2Ugb2YgaW5kZXgtb25seS1zY2FuIHBs
YW4KICAgICAgICAgdHlwZXMgKHNlZSA8eHJlZiBsaW5rZW5kPSJpbmRleGVzLWluZGV4LW9ubHkt
c2NhbnMiLz4pLgotICAgICAgICBUaGUgZGVmYXVsdCBpcyA8bGl0ZXJhbD5vbjwvbGl0ZXJhbD4u
CisgICAgICAgIFRoZSBkZWZhdWx0IGlzIDxsaXRlcmFsPm9uPC9saXRlcmFsPi4gSG93ZXZlciwg
dGhpcyBzZXR0aW5nIGhhcyBubyBlZmZlY3QgaWYKKyAgICAgICAgPHhyZWYgbGlua2VuZD0iZ3Vj
LWVuYWJsZS1pbmRleHNjYW4iLz4gaXMgc2V0IHRvIDxsaXRlcmFsPm9mZjwvbGl0ZXJhbD4uCiAg
ICAgICAgPC9wYXJhPgogICAgICAgPC9saXN0aXRlbT4KICAgICAgPC92YXJsaXN0ZW50cnk+Ci0t
IAoyLjM0LjEKCg==
--00000000000079e52106251a4900--