postgresql/contrib/btree_gist
Melanie Plageman 62407d26b7 Stabilize btree_gist test against on-access VM setting
The btree_gist enum test expects a bitmap heap scan. Since b46e1e54d0
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
2026-04-21 17:32:45 -04:00
..
data Add btree_gist support for enum types. 2017-03-21 10:43:27 -04:00
expected Stabilize btree_gist test against on-access VM setting 2026-04-21 17:32:45 -04:00
sql Stabilize btree_gist test against on-access VM setting 2026-04-21 17:32:45 -04:00
.gitignore Support "make check" in contrib 2011-04-25 22:27:11 +03:00
btree_bit.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_bool.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_bytea.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_cash.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_date.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_enum.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_float4.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_float8.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_gist--1.0--1.1.sql Add index-only scan support to btree_gist. 2015-03-27 23:35:16 +02:00
btree_gist--1.1--1.2.sql Make contrib modules' installation scripts more secure. 2020-08-10 10:44:42 -04:00
btree_gist--1.2--1.3.sql Add uuid to the set of types supported by contrib/btree_gist. 2016-11-29 14:08:34 -05:00
btree_gist--1.3--1.4.sql Add support for EUI-64 MAC addresses as macaddr8 2017-03-15 11:16:25 -04:00
btree_gist--1.4--1.5.sql Add btree_gist support for enum types. 2017-03-21 10:43:27 -04:00
btree_gist--1.5--1.6.sql Update btree_gist extension for parallel query 2020-07-20 13:59:50 +03:00
btree_gist--1.6--1.7.sql Fix gist_bool_ops to use gbtreekey2 2021-11-08 01:14:55 +01:00
btree_gist--1.7--1.8.sql btree_gist: Merge the last two versions into version 1.8 2025-07-10 12:23:04 +09:00
btree_gist--1.8--1.9.sql Create btree_gist v1.9, in which inet/cidr opclasses aren't default. 2026-01-08 13:56:08 -05:00
btree_gist--1.9.sql Create btree_gist v1.9, in which inet/cidr opclasses aren't default. 2026-01-08 13:56:08 -05:00
btree_gist.c Rename gist stratnum support function 2025-06-02 08:41:27 +02:00
btree_gist.control Create btree_gist v1.9, in which inet/cidr opclasses aren't default. 2026-01-08 13:56:08 -05:00
btree_gist.h Add trailing commas to enum definitions 2023-10-26 09:20:54 +02:00
btree_inet.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_int2.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_int4.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_int8.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_interval.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_macaddr.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_macaddr8.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_numeric.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_oid.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_text.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_time.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_ts.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
btree_utils_num.c Use more palloc_object() and palloc_array() in contrib/ 2025-12-05 16:40:26 +09:00
btree_utils_num.h Remove unused #include's from contrib, pl, test .c files 2024-10-28 08:02:17 +01:00
btree_utils_var.c Improve type handling of varlena structures 2026-02-11 07:33:24 +09:00
btree_utils_var.h Fix a set of typos and grammar issues across the tree 2026-04-21 14:46:22 +09:00
btree_uuid.c Mark commented out code as unused 2026-01-22 12:44:07 +01:00
Makefile Remove now-useless btree_gist--1.2.sql script. 2026-01-08 14:09:58 -05:00
meson.build Remove now-useless btree_gist--1.2.sql script. 2026-01-08 14:09:58 -05:00