diff options
| author | Tomas Vondra <tomas.vondra@postgresql.org> | 2024-04-17 16:12:03 +0200 |
|---|---|---|
| committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2024-04-17 16:12:06 +0200 |
| commit | a89cd7bfcdbb45a2c23b4b6004f4503f04f83bd7 (patch) | |
| tree | d31e6a4cce65d41528e253e293aa6cae9e0bead9 | |
| parent | 5165d43680dafafcc3d8c1a0a781b9aa33064ea6 (diff) | |
| download | postgresql-a89cd7bfcdbb45a2c23b4b6004f4503f04f83bd7.tar.gz postgresql-a89cd7bfcdbb45a2c23b4b6004f4503f04f83bd7.zip | |
Revert "Stabilize test of BRIN parallel create"
This reverts commit 4d916dd876c3. The goal of that commit was to
stabilize a test of parallel BRIN build, but using a TEMPORARY table
disables parallel index builds on that table, making the test useless.
Discussion: https://postgr.es/m/95d9cd43-5a92-407c-b7e4-54cd303630fe%40enterprisedb.com
| -rw-r--r-- | contrib/pageinspect/expected/brin.out | 2 | ||||
| -rw-r--r-- | contrib/pageinspect/sql/brin.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/contrib/pageinspect/expected/brin.out b/contrib/pageinspect/expected/brin.out index e59451af4b2..67c3549a124 100644 --- a/contrib/pageinspect/expected/brin.out +++ b/contrib/pageinspect/expected/brin.out @@ -109,7 +109,7 @@ SELECT (COUNT(*) = (SELECT relpages FROM pg_class WHERE relname = 'test2')) AS r DROP TABLE test1; DROP TABLE test2; -- Test that parallel index build produces the same BRIN index as serial build. -CREATE TEMPORARY TABLE brin_parallel_test (a int, b text, c bigint) WITH (fillfactor=40); +CREATE TABLE brin_parallel_test (a int, b text, c bigint) WITH (fillfactor=40); -- Generate a table with a mix of NULLs and non-NULL values (and data suitable -- for the different opclasses we build later). INSERT INTO brin_parallel_test diff --git a/contrib/pageinspect/sql/brin.sql b/contrib/pageinspect/sql/brin.sql index ac375a427d1..a25969d58f0 100644 --- a/contrib/pageinspect/sql/brin.sql +++ b/contrib/pageinspect/sql/brin.sql @@ -56,7 +56,7 @@ DROP TABLE test1; DROP TABLE test2; -- Test that parallel index build produces the same BRIN index as serial build. -CREATE TEMPORARY TABLE brin_parallel_test (a int, b text, c bigint) WITH (fillfactor=40); +CREATE TABLE brin_parallel_test (a int, b text, c bigint) WITH (fillfactor=40); -- Generate a table with a mix of NULLs and non-NULL values (and data suitable -- for the different opclasses we build later). |