[taler-grid5k] 33/189: try adding index

[gnunet]

This is an automated email from the git hooks/post-receive script.

marco-boss pushed a commit to branch master
in repository grid5k.

commit 877eb8baa9265df81a113af6f8124647bc1cab6a
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Sat Feb 26 16:50:01 2022 +0100

    try adding index
---
 sql/exchange-0001.sql | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/sql/exchange-0001.sql b/sql/exchange-0001.sql
index 441df3a..dbcba25 100644
--- a/sql/exchange-0001.sql
+++ b/sql/exchange-0001.sql
@@ -88,6 +88,11 @@ CREATE TABLE IF NOT EXISTS wire_targets_default
   PARTITION OF wire_targets
   FOR VALUES WITH (MODULUS 1, REMAINDER 0);
 
+CREATE INDEX IF NOT EXISTS wire_targets_serial_id_index
+  ON wire_targets
+  (wire_targets_serial_id
+  );
+
 CREATE TABLE IF NOT EXISTS reserves
   (reserve_uuid BIGINT GENERATED BY DEFAULT AS IDENTITY
   ,reserve_pub BYTEA PRIMARY KEY CHECK(LENGTH(reserve_pub)=32)

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.