pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add regression test for BRIN parallel builds
Date: Sun, 14 Apr 2024 16:59:12 +0000
Message-ID: <E1rw3CB-0022xf-NF@gemulon.postgresql.org> (raw)

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(+)



Message-ID: <E1rw3CB-0022xf-NF@gemulon.postgresql.org>
Permalink:  ../E1rw3CB-0022xf-NF@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1rw3CB-0022xf-NF@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: tomas.vondra@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Add regression test for BRIN parallel builds
  In-Reply-To: <E1rw3CB-0022xf-NF@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox