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

From: Andrei Lepikhov <lepihov(at)gmail(dot)com>
To: Ed Sabol <edwardjsabol(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Major performance degradation with joins in 15.8 or 15.7?
Date: 2024-11-09 01:21:07
Message-ID: d06b50a5-30fa-40d7-9cdf-aeddb3bf58e4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2024-11-09 10:49:34 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
Previous Message Ed Sabol 2024-11-08 20:32:54 Re: Major performance degradation with joins in 15.8 or 15.7?