Convert participant_events low-cardinality columns to btree (digital-…

…asset#8667) CHANGELOG_BEGIN - Changed index method type back to B-Tree from Hash for: participant_events_template_id_idx, participant_events_contract_id_idx indices of participant_events table CHANGELOG_END
kgeonw · Feb 1, 2021 · 3ce8a67 · 3ce8a67
1 parent 310f893
commit 3ce8a67
Show file tree

Hide file tree

Showing 2 changed files with 9 additions and 0 deletions.
diff --git a/...integration-api/src/main/resources/db/migration/postgres/V42__Convert_hash_indices.sha256 b/...integration-api/src/main/resources/db/migration/postgres/V42__Convert_hash_indices.sha256
@@ -0,0 +1 @@
+70cf33f279dad1830b9a2143e2cf1b50a49b7cb5d9843c0baaf4d113dc839440
diff --git a/...nt-integration-api/src/main/resources/db/migration/postgres/V42__Convert_hash_indices.sql b/...nt-integration-api/src/main/resources/db/migration/postgres/V42__Convert_hash_indices.sql
@@ -0,0 +1,8 @@
+-- Copyright (c) 2021 Digital Asset (Switzerland) GmbH and/or its affiliates. All rights reserved.
+-- SPDX-License-Identifier: Apache-2.0
+
+drop index if exists participant_events_template_id_idx;
+create index on participant_events(template_id);
+
+drop index if exists participant_events_contract_id_idx;
+create index on participant_events(contract_id);
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		70cf33f279dad1830b9a2143e2cf1b50a49b7cb5d9843c0baaf4d113dc839440