diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2020-04-06 12:29:54 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2020-04-06 12:29:54 -0400 |
commit | e82b6e00ac60d0716161352d448660c014e092a7 (patch) | |
tree | df9a9402ac1982603fdbf6b0958b5b6e86657394 | |
parent | 3f77a670241d114eb4b65ad6eed52298d28dcef8 (diff) |
Stabilize new GIN test case in 9.5 branch.
In 9.6 and up, gin_test_tbl has autovacuum_enabled = off thanks to
commit f8a1c1d5a. 9.5 lacked that, which allowed autovacuum to
bollix the results of the test case added by commit 8150f7813.
We could fool with disabling seqscan around that test, but making
this branch look more like the later ones seems a better answer.
Per buildfarm member protosciurus. (I'm not very sure why
protosciurus is the only animal to report this so far; but it'd
clearly be a timing-related failure, so it's not astonishing that
only some machines would show it.)
-rw-r--r-- | src/test/regress/expected/gin.out | 2 | ||||
-rw-r--r-- | src/test/regress/sql/gin.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/gin.out b/src/test/regress/expected/gin.out index 59a039c9dd3..fa00e0f5e25 100644 --- a/src/test/regress/expected/gin.out +++ b/src/test/regress/expected/gin.out @@ -4,7 +4,7 @@ -- There are other tests to test different GIN opclasses. This is for testing -- GIN itself. -- Create and populate a test table with a GIN index. -create table gin_test_tbl(i int4[]); +create table gin_test_tbl(i int4[]) with (autovacuum_enabled = off); create index gin_test_idx on gin_test_tbl using gin (i) with (fastupdate = on); insert into gin_test_tbl select array[1, 2, g] from generate_series(1, 20000) g; insert into gin_test_tbl select array[1, 3, g] from generate_series(1, 1000) g; diff --git a/src/test/regress/sql/gin.sql b/src/test/regress/sql/gin.sql index 870876a6b95..6cfb6683a6c 100644 --- a/src/test/regress/sql/gin.sql +++ b/src/test/regress/sql/gin.sql @@ -5,7 +5,7 @@ -- GIN itself. -- Create and populate a test table with a GIN index. -create table gin_test_tbl(i int4[]); +create table gin_test_tbl(i int4[]) with (autovacuum_enabled = off); create index gin_test_idx on gin_test_tbl using gin (i) with (fastupdate = on); insert into gin_test_tbl select array[1, 2, g] from generate_series(1, 20000) g; insert into gin_test_tbl select array[1, 3, g] from generate_series(1, 1000) g; |