Re: unstable query plan on pg 16,17,18 - Mailing list pgsql-performance

From Andrei Lepikhov
Subject Re: unstable query plan on pg 16,17,18
Date
Msg-id 0c8b9845-a2ac-4613-8075-45dc55911143@gmail.com
Whole thread Raw
In response to Re: unstable query plan on pg 16,17,18  (Attila Soki <atiware@gmx.net>)
Responses Re: unstable query plan on pg 16,17,18
List pgsql-performance
On 24/2/26 16:50, Attila Soki wrote:
> Now with join_collapse_limit=7 works for me and I am not able to flip the plan. makes that sense?

It is almost a game of chance. But if it solves your problem - why not ;)?

> 
> should I still test with increased statistic on table_k.dp_end_dat as Laurenz suggested?

Yes, it may provide us additional info for developing.

> 
> I could now share some general infos about the query, if you still interested.
Yes, we still have a problem. So, any additional info that can let us 
build a repro is appreciated.

-- 
regards, Andrei Lepikhov,
pgEdge



pgsql-performance by date:

Previous
From: Attila Soki
Date:
Subject: Re: unstable query plan on pg 16,17,18
Next
From: Attila Soki
Date:
Subject: Re: unstable query plan on pg 16,17,18