On 25/9/2025 12:41, Frédéric Yhuel wrote:
> So, on SQL Server, you can do this:
> CREATE STATISTICS FooStats ON foo (ackid, crit) WHERE crit = 'WARNING';
>
> It would be great to have a similar feature in PostgreSQL.Nice! Thanks for the report. I think the only reason why
Postgres
doesn't have it yet is the computational cost. SQL Server utilises a
separate background worker to manage this vast amount of statistical
data. Not sure that Postgres core wants it. Maybe one more contrib
extension can be a solution?
--
regards, Andrei Lepikhov,
pgEdge