Re: Postgres: Queries are too slow after upgrading to PG17 from PG15

On Wed, Jul 30, 2025 at 3:48 PM Todd Cook <cookt@blackduck.com> wrote:
> I work at the same company as Sajith, but on a different product.  The reproducer he
> provided is just a sample; it's not the only problem.  Load testing in my team shows
> that PG 17 is about 4x slower than PG 15 across the board.  It's bordering on unusable
> for production deployments.

I suggest that you rewrite affected queries to make them join against
a VALUES() with the same constants as those currently used in the
larger IN() list. If you're not sure whether the set of constants from
the application will be reliably unique, you can use DISTINCT to make
sure.

--
Peter Geoghegan