Hi,
On 2025-09-16 15:55:49 +0300, Core Studios Inc. wrote:
> Following up to correct my previous email: the query plan did not really
> change - we see Bitmap Heap Scans even before the upgrade. Therefore, the
> query plan doesn't seem to have changed after the upgrade.
>
> However after the upgrade it seems that those queries are doing more disk IO
> (increased index_blocks_read in that table).
Without the query + plan I can't judge whether the query could even have
benefited from the, fairly narrow, optimization...
Greetings,
Andres