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

From Andrei Lepikhov
Subject Re: Indexes on expressions with multiple columns and operators
Date
Msg-id 57d14051-d5c6-4af2-a6e9-7e362dea354d@gmail.com
Whole thread Raw
In response to Re: Indexes on expressions with multiple columns and operators  (Frédéric Yhuel <frederic.yhuel@dalibo.com>)
List pgsql-performance
On 23/9/2025 15:31, Frédéric Yhuel wrote:
> To get back to the topic of partitioned statistics, do you know if SQL 
> Server is smart enough to handle this case [1] that we discussed last 
> year? (with filtered statistics)
> 
> [1] https://www.postgresql.org/message-id/flat/b860c71a-7cab-4d88- 
> ad87-8c1f2eea9ae8%40dalibo.com
Not sure. After changing employers recently, I've lost access to the SQL 
Server instance :( and can't check how smart it is. However, as I 
recall, they design many features, and sometimes their optimiser finds a 
good solution/estimation through an unexpected approach.

-- 
regards, Andrei Lepikhov,
pgEdge



pgsql-performance by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Poor performance with row wise comparisons
Next
From: Andrei Lepikhov
Date:
Subject: Re: Indexes on expressions with multiple columns and operators