Re: BUG #19076: Generic query plan is extremely slow

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Premal Patel <premal(dot)patel(at)veeva(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19076: Generic query plan is extremely slow
Date: 2025-10-08 11:41:03
Message-ID: e196978c46177dbabd74d96f6c6d0214d5b8b82a.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, 2025-10-08 at 07:17 -0400, Premal Patel wrote:
> Would it be unsafe to set “plan_cache_mode” to “force_custom_plan”
> for the entirety of the connection?

No, that's not unsafe at all, but you'd lose the performance advantage
of reusing plans, which can be substantial for short statements.

Yours,
Laurenz Albe

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Marco Boeringa 2025-10-08 12:13:28 Re: Potential "AIO / io workers" inter-worker locking issue in PG18?
Previous Message Premal Patel 2025-10-08 11:17:03 Re: BUG #19076: Generic query plan is extremely slow