Stabilize btree_gist test against on-access VM setting
Melanie Plageman <melanieplageman@gmail.com>
Author:
Melanie Plageman <melanieplageman@gmail.com>
Date: 2026-04-21T21:32:45Z
Releases:
19 (unreleased)
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
Files
| Path | Change | +/− |
|---|---|---|
| contrib/btree_gist/expected/enum.out | modified | +1 −1 |
| contrib/btree_gist/sql/enum.sql | modified | +1 −1 |
Discussion
- eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) 168 messages · 2025-06-23 → 2026-04-21