Re: BUG #19076: Generic query plan is extremely slow - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: BUG #19076: Generic query plan is extremely slow
Date
Msg-id e196978c46177dbabd74d96f6c6d0214d5b8b82a.camel@cybertec.at
Whole thread Raw
In response to BUG #19076: Generic query plan is extremely slow  (PG Bug reporting form <noreply@postgresql.org>)
List 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



pgsql-bugs by date:

Previous
From: Premal Patel
Date:
Subject: Re: BUG #19076: Generic query plan is extremely slow
Next
From: Marco Boeringa
Date:
Subject: Re: Potential "AIO / io workers" inter-worker locking issue in PG18?