Melanie Plageman b93961add9 Stabilize btree_gist test against on-access VM setting ...

The btree_gist enum test expects a bitmap heap scan. Since 0172721d14
enabled setting the VM during on-access pruning and 502167cfe 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 <[email protected]>
Author: Melanie Plageman <[email protected]>
Discussion: https://postgr.es/m/46733d68-aec0-4d09-8120-4c66b87047a4%40gmail.com

2026-04-21 17:32:45 -04:00

..

bit.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

bool.out

Fix planner to consider matches to boolean columns in extension indexes.

2022-09-02 17:01:51 -04:00

bytea.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

cash.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

char_1.out

Fix results of index-only scans on btree_gist char(N) indexes.

2022-01-08 14:54:39 -05:00

char.out

Fix results of index-only scans on btree_gist char(N) indexes.

2022-01-08 14:54:39 -05:00

cidr.out

Create btree_gist v1.9, in which inet/cidr opclasses aren't default.

2026-01-08 13:56:08 -05:00

date.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

enum.out

Stabilize btree_gist test against on-access VM setting

2026-04-21 17:32:45 -04:00

float4.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

float8.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

inet.out

Create btree_gist v1.9, in which inet/cidr opclasses aren't default.

2026-01-08 13:56:08 -05:00

init.out

Test all contrib-created operator classes with amvalidate.

2016-11-29 15:05:22 -05:00

int2.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

int4.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

int8.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

interval.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

macaddr8.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

macaddr.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

not_equal.out

Ensure plan stability in contrib/btree_gist regression test.

2016-05-12 20:04:38 -04:00

numeric.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

oid.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

partitions.out

Allow some exclusion constraints on partitions

2023-07-12 09:25:17 +02:00

stratnum.out

Rename gist stratnum support function

2025-06-02 08:41:27 +02:00

text_1.out

Add index-only scan support to btree_gist.

2015-03-27 23:35:16 +02:00

text.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

time.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

timestamp.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

timestamptz.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

timetz.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

uuid.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

varbit.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

varchar_1.out

…

varchar.out

Revert "Add sortsupport for gist_btree opclasses, for faster index builds."

2021-04-07 14:33:21 +03:00

without_overlaps.out

Add temporal FOREIGN KEY contraints

2024-09-17 11:29:30 +02:00