On Fri, May 23, 2025 at 10:01:13AM -0400, Peter Geoghegan wrote: > On Thu, May 22, 2025 at 10:24 PM Bruce Momjian <br...@momjian.us> wrote: > > I see your point that we are not defining what this does. I went with > > the attached text. > > You propose the wording is "This allows muti-column btree indexes to > be used by queries that only reference the second or later indexed > columns". > > I think that your wording is a big improvement. I personally would > have emphasized the absence of a "=" condition, rather than the > presence of another condition on a later column, since there are cases > where the first column is referenced but skip scan can still be used > (e.g., when there one or more inequalities on the first column, plus a > "=" condition on the second column). I can live with this wording, > though.
I was able to squeeze in this detail in the attached, applied patch. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future.
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index ea0b23bf1fe..2ae03065f94 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -469,8 +469,8 @@ Allow skip scans of btree indexes (Peter Geoghegan) </para> <para> -This allows muti-column btree indexes to be used by queries that only -reference the second or later indexed columns. +This allows multi-column btree indexes to be used by queries that only +equality-reference the second or later indexed columns. </para> </listitem>
