pgsql: Add regression test for BRIN parallel builds

From: Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add regression test for BRIN parallel builds
Date: 2024-04-14 16:59:12
Message-ID: E1rw3CB-0022xf-NF@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add regression test for BRIN parallel builds

Adds a regression test for parallel CREATE INDEX for BRIN indexes, to
improve coverage for BRIN code, particularly code to allow parallel
index builds introduced by b43757171470.

The test is added to pageinspect, as that allows comparing the index to
one built without parallelism. Another option would be to just build the
index with parallelism and then check it produces correct results. But
checking the index is exactly as if built without parallelism makes
these query checks unnecessary.

Discussion: https://postgr.es/m/1df00a66-db5a-4e66-809a-99b386a06d86%40enterprisedb.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8225c2fd40cd9f7d60a826affeacdd8bf0de7bee

Modified Files
--------------
contrib/pageinspect/expected/brin.out | 101 ++++++++++++++++++++++++++++++++++
contrib/pageinspect/sql/brin.sql | 91 ++++++++++++++++++++++++++++++
2 files changed, 192 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Tomas Vondra 2024-04-14 18:38:22 pgsql: Fix unnecessary padding in incremental backups
Previous Message Tomas Vondra 2024-04-14 16:27:23 pgsql: Use the correct PG_DETOAST_DATUM macro in BRIN