Re: Incorrect result of bitmap heap scan. - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Incorrect result of bitmap heap scan.
Date
Msg-id 745E01F7-E62F-491D-963A-B0793AEDA9F5@anarazel.de
Whole thread Raw
In response to Re: Incorrect result of bitmap heap scan.  ("Core Studios Inc." <corestudiosinc@gmail.com>)
Responses Re: Incorrect result of bitmap heap scan.
Re: Incorrect result of bitmap heap scan.
List pgsql-hackers
Hi,

On September 16, 2025 7:57:54 AM EDT, "Core Studios Inc." <corestudiosinc@gmail.com> wrote:
>Hello,
>
>We noticed a sustained increased in IO Wait of read queries after upgrading from 13.13 to 13.21. Eventually, we
narrowedit down to a spike in index_blocks_read of a certain table where Bitmap Heap Scans do happen. 
>
>Do you think that this change (i.e. removing the optimization) could be what caused this regression?

You're not providing enough details for us to answer that question. We'd need an explain verbose for the query.

Greetings,

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.



pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Improve pg_sync_replication_slots() to wait for primary to advance
Next
From: Tom Lane
Date:
Subject: Re: Improving the names generated for indexes on expressions