Re: Major performance degradation with joins in 15.8 or 15.7?

On 9/11/2024 03:32, Ed Sabol wrote:
> CREATE STATISTICS tablename_stats_rt_nd  (ndistinct) ON relation, type FROM tablename;
The only one thing I want to note. It is enough to execute:

CREATE STATISTICS tablename_stats  (mcv,ndistinct,dependencies)
ON relation, type FROM tablename;

And all the statistics will be build over any possible combination of 
(relation, type). So, you don't need to call CREATE STATISTICS more than 
once.

-- 
regards, Andrei Lepikhov