Re: Indexes on expressions with multiple columns and operators - Mailing list pgsql-performance

From Frédéric Yhuel
Subject Re: Indexes on expressions with multiple columns and operators
Date
Msg-id 76fbd9ef-1fbb-49f0-bc8b-844462b18d1d@dalibo.com
Whole thread Raw
In response to Re: Indexes on expressions with multiple columns and operators  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance

On 9/18/25 18:40, Tom Lane wrote:
> The attached fixes things so it works like it did pre-a391ff3c3.
> 

Indeed, it works well!

> 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.

It looks like an interesting homework for an aspiring hacker :-)
So I'll try to devise one, too.




pgsql-performance by date:

Previous
From: David Rowley
Date:
Subject: Re: Why isn't PG using an index-only scan?
Next
From: Andrei Lepikhov
Date:
Subject: Re: Why isn't PG using an index-only scan?