agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Melanie Plageman <melanieplageman@gmail.com>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Stabilize btree_gist test against on-access VM setting
Date: Tue, 21 Apr 2026 21:34:39 +0000
Message-ID: <E1wFIjv-0023qL-19@gemulon.postgresql.org> (raw)
Stabilize btree_gist test against on-access VM setting
The btree_gist enum test expects a bitmap heap scan. Since b46e1e54d07
enabled setting the VM during on-access pruning and 378a21618 set
pd_prune_xid on INSERT, scans of enumtmp may set pages all-visible.
If autovacuum or autoanalyze then updates pg_class.relallvisible, the
planner could choose an index-only scan instead.
Make the enumtmp a temp table to exclude it from autovacuum/autoanalyze.
Reported-by: Alexander Lakhin <exclusion@gmail.com>
Author: Melanie Plageman <melanieplageman@gmail.com>
Discussion: https://postgr.es/m/46733d68-aec0-4d09-8120-4c66b87047a4%40gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/62407d26b7c9e619ed696fced88fdacc5d1ae522
Modified Files
--------------
contrib/btree_gist/expected/enum.out | 2 +-
contrib/btree_gist/sql/enum.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
Message-ID: <E1wFIjv-0023qL-19@gemulon.postgresql.org>
Permalink: ../E1wFIjv-0023qL-19@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1wFIjv-0023qL-19@gemulon.postgresql.org
reply
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-committers@postgresql.org
Cc: melanieplageman@gmail.com, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Stabilize btree_gist test against on-access VM setting
In-Reply-To: <E1wFIjv-0023qL-19@gemulon.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox