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