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
Dear All,
we have hit a serious performance regression going from 10.23 → 16.4 as
far as tds_fdw (MS SQL) FDW is concerned. To cut the long story short, I
recreated the good fast “old” (pgsql 10) setup on the same vm as the
slow “new” (pgsql 16). Here is the bug report on github :
https://gi
On Nov 7, 2024, at 9:54 PM, Andrei Lepikhov wrote:
> On 11/8/24 09:45, Ed Sabol wrote:
>> On Nov 7, 2024, at 9:27 PM, Andrei Lepikhov wrote:
>>> Postgres didn't want Materialize in this example because of the low
>>> estimation on its outer subquery. AFAIC, by increasing the *_page_cost's
>>> v
