Re: Performance regression when adding LIMIT 1 to a query

On Mon, Apr 7, 2025 at 4:06 PM Artur Zakirov wrote: > On Mon, 7 Apr 2025 at 14:45, Costa Alexoglou wrote: > > ... > > with a plan: > > ``` > > Gather Merge (cost=115584.47..118515.35 rows=25120 width=824) (actual > time=46.004..74.267 rows=29653 loops=1) > > Workers Planned: 2 > > Workers L

Re: Performance regression when adding LIMIT 1 to a query

On Mon, 7 Apr 2025 at 14:45, Costa Alexoglou wrote: > ... > with a plan: > ``` > Gather Merge (cost=115584.47..118515.35 rows=25120 width=824) (actual > time=46.004..74.267 rows=29653 loops=1) > Workers Planned: 2 > Workers Launched: 2 > -> Sort (cost=114584.45..114615.85 rows=12560 widt