Horton

Re: Indexes on expressions with multiple columns and operators

Andrei Lepikhov <lepihov@gmail.com>

View thread
From: Andrei Lepikhov <lepihov@gmail.com>
To: Frédéric Yhuel <frederic.yhuel@dalibo.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-performance@lists.postgresql.org" <pgsql-performance@lists.postgresql.org>, Jehan-Guillaume de Rorthais <jgdr@dalibo.com>, Christophe Courtois <christophe.courtois@dalibo.com>, Laurenz Albe <laurenz.albe@cybertec.at>
Date: 2025-10-13T13:56:59Z
Lists: 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