pgsql: Use custom hash opclass for hash partition pruning

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Use custom hash opclass for hash partition pruning
Date: 2018-04-13 15:27:46
Message-ID: E1f70c6-0003Dc-4g@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Use custom hash opclass for hash partition pruning

This custom opclass was already in use in other tests -- defined
independently in every such file. Move the definition to the earliest
test that uses it, and keep it around so that later tests can reuse it.
Use it in the tests for pruning of hash partitioning, and since this
makes the second expected file unnecessary, put those tests back in
partition_prune.sql whence they sprang.

Author: Amit Langote
Discussion: https://postgr.es/m/CA%2BTgmoZ0D5kJbt8eKXtvVdvTcGGWn6ehWCRSZbWytD-uzH92mQ%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/fafec4cce814b9b15991b62520dc5e5e84655a8a

Modified Files
--------------
src/test/regress/expected/alter_table.out | 15 +-
src/test/regress/expected/hash_part.out | 23 +--
src/test/regress/expected/insert.out | 32 +++-
src/test/regress/expected/partition_prune.out | 191 +++++++++++++++++++++
src/test/regress/expected/partition_prune_hash.out | 189 --------------------
.../regress/expected/partition_prune_hash_1.out | 187 --------------------
src/test/regress/parallel_schedule | 2 +-
src/test/regress/serial_schedule | 1 -
src/test/regress/sql/alter_table.sql | 15 +-
src/test/regress/sql/hash_part.sql | 24 +--
src/test/regress/sql/insert.sql | 36 +++-
src/test/regress/sql/partition_prune.sql | 44 ++++-
src/test/regress/sql/partition_prune_hash.sql | 41 -----
13 files changed, 305 insertions(+), 495 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-04-13 16:54:04 pgsql: In libpq, free any partial query result before collecting a serv
Previous Message Alvaro Herrera 2018-04-13 14:00:21 pgsql: Attempt to stabilize partition_prune test output (2)