From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: mguissine@gmail.com
Subject: BUG #17652: Performance degradation after migrating from v13.4 to v14.4
Date: Wed, 19 Oct 2022 16:11:15 +0000
Message-ID: <17652-6dc857c92440a189@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17652
Logged by: Michael Guissine
Email address: mguissine@gmail.com
PostgreSQL version: 14.4
Operating system: AWS RDS
Description:
Hello,
We recently upgraded our AWS RDS instances to PG 14.4 and are seeing weird
performance degradation. The issue seems to be isolated to one specific use
case which is querying partitioned table with a large number of elements in
the IN clause. In our setup, we observed that Postgres is switching from
Index Scan to Bitmap Index Scan/Bitmap Heap Scan if the number of elements
in the IN clause is above 60, below 60 the Index Scan is performed on all
partitions.
Query and query plan are attached below. We also tried to turn off
enable_bitmapscan and observed that query is performing well which was our
experience in the previous version (pg 13.4)
https://explain.depesz.com/s/F587
Thank you!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, mguissine@gmail.com
Subject: Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4
In-Reply-To: <17652-6dc857c92440a189@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox