public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Peter Geoghegan <[email protected]>
Cc: PostgreSQL-development <[email protected]>
Subject: Re: PG 18 release notes draft committed
Date: Fri, 23 May 2025 17:03:53 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAH2-Wzko57+sT=FcxHHo7jnPLhh35up_5aAvogLtj_D9bATsgQ@mail.gmail.com>
References: <[email protected]>
<CAH2-Wz=2CWXgO1+uyR-VfN3ALMtFnfTtXK-VtkoQQ89ogm=4sg@mail.gmail.com>
<[email protected]>
<CAH2-Wzko57+sT=FcxHHo7jnPLhh35up_5aAvogLtj_D9bATsgQ@mail.gmail.com>
On Fri, May 23, 2025 at 10:01:13AM -0400, Peter Geoghegan wrote:
> On Thu, May 22, 2025 at 10:24 PM Bruce Momjian <[email protected]> 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 <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
Attachments:
[text/x-diff] master.diff (544B, ../[email protected]/2-master.diff)
download | inline diff:
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>
view thread (147+ 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]
Subject: Re: PG 18 release notes draft committed
In-Reply-To: <[email protected]>
* 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