Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours)

From: Tomas Vondra <tomas(at)vondra(dot)me>
To: Adrian Mönnich <adrian(dot)moennich(at)cern(dot)ch>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: Andres Freund <andres(at)anarazel(dot)de>, Tomas Vondra <tv(at)fuzzy(dot)cz>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Subject: Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours)
Date: 2026-08-14 19:11:38
Message-ID: 5fe6919a-2ab3-4e00-a8ed-94c06b2ac3e0@vondra.me
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 8/14/26 17:10, Adrian Mönnich wrote:
> Hi,
>
> ping - any updates on this bug report?
>
> Cheers,
> Adrian
>

Sorry, I don't think anyone took care of fixing this, due to the work
with stabilizing 19 and handling an influx of other reports.

I'll try to investigate this issue again sometime next week, once I get
back home from travel. At this point it's too early to say if we will
backpatch the fix - we'll certainly try to, but it depends on how
invasive the fix happens to be.

regards

--
Tomas Vondra

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Tom Lane 2026-08-14 18:51:03 Re: BUG #19619: WHERE scale(n) = 1 pushed past GROUP BY / window PARTITION BY, wrong COUNT