public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ranier Vilela <[email protected]>
To: Tom Lane <[email protected]>
Cc: Frédéric Yhuel <[email protected]>
Cc: [email protected] <[email protected]>
Cc: Jehan-Guillaume de Rorthais <[email protected]>
Cc: Christophe Courtois <[email protected]>
Cc: Laurenz Albe <[email protected]>
Subject: Re: Indexes on expressions with multiple columns and operators
Date: Thu, 18 Sep 2025 13:48:08 -0300
Message-ID: <CAEudQApK3JRz75X8_8zSiC3oAMgnZRcLsjYTqtwQWH=Ytdh21Q@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

Em qui., 18 de set. de 2025 às 13:40, Tom Lane <[email protected]> escreveu:

> I wrote:
> > Sigh ... so the answer is this used to work (since commit 39df0f150)
> > and then I carelessly broke it in commit a391ff3c3.  If you try this
> > test case in versions 9.5..11 you get a spot-on rowcount estimate.
> > Serves me right for not having a test case I guess, but I'm astonished
> > that nobody complained sooner.
>
> The attached fixes things so it works like it did pre-a391ff3c3.
>
> I spent some time trying to devise a test case, and was reminded
> of why I didn't have one before: it's hard to make a case that
> will be robust enough to not show diffs in the buildfarm.
> I'll keep thinking about that though.
>
One question, make difference return -1.0 (float point notation)?
If not, static analyzers will have less work.

best regards,
Ranier Vilela

view thread (26+ 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], [email protected], [email protected], [email protected]
  Subject: Re: Indexes on expressions with multiple columns and operators
  In-Reply-To: <CAEudQApK3JRz75X8_8zSiC3oAMgnZRcLsjYTqtwQWH=Ytdh21Q@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