Message-ID: <0c8b9845-a2ac-4613-8075-45dc55911143@gmail.com>
Date: Tue, 24 Feb 2026 16:57:04 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: unstable query plan on pg 16,17,18
To: Attila Soki <atiware@gmx.net>
Cc: pgsql-performance@postgresql.org, Laurenz Albe <laurenz.albe@cybertec.at>
References: <ECA94B5A-E5B4-45F7-B1B4-9BF754083164@gmx.net>
 <e94e4d006975792d72e667bbd0499f9ddec4ed58.camel@cybertec.at>
 <64ddfe83-317c-4cf1-b04f-cb74d9f40629@gmail.com>
 <529E2365-6C3F-4BDA-9625-312F3A023C5B@gmx.net>
 <5bace3e5-3d6b-4f81-92a9-9ff4e9e5de53@gmail.com>
 <1C445A2F-3256-4F04-B55D-9850581FF39A@gmx.net>
 <0dd76506-053e-4a30-9f95-9dc324e8e1fb@gmail.com>
 <FF816253-DD7D-4AC2-8CD1-8A5ACB1D1113@gmx.net>
 <1388B912-7E9A-475A-93AA-67FB99A084BC@gmx.net>
Content-Language: en-US
From: Andrei Lepikhov <lepihov@gmail.com>
In-Reply-To: <1388B912-7E9A-475A-93AA-67FB99A084BC@gmx.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/0c8b9845-a2ac-4613-8075-45dc55911143%40gmail.com>
Precedence: bulk

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