[taler-grid5k] 35/189: add index on known_coins to try to fix recoup_by_reserve

[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 51291ae565fcb29de96cc4a47291d036a5361822
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Sat Feb 26 21:41:56 2022 +0100

    add index on known_coins to try to fix recoup_by_reserve
---
 sql/exchange-0001.sql | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/sql/exchange-0001.sql b/sql/exchange-0001.sql
index d941cf7..ef36bfe 100644
--- a/sql/exchange-0001.sql
+++ b/sql/exchange-0001.sql
@@ -88,7 +88,7 @@ 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
+CREATE INDEX IF NOT EXISTS wire_targets_wire_target_serial_id_index
   ON wire_targets
   (wire_target_serial_id
   );
@@ -342,6 +342,10 @@ CREATE INDEX IF NOT EXISTS 
known_coins_by_known_coin_id_index
   ON known_coins
   (known_coin_id);
 
+CREATE INDEX IF NOT EXISTS known_coins_denominations_serial_index
+  ON known_coins
+  (denominations_serial);
+
 
 CREATE TABLE IF NOT EXISTS refresh_commitments
   (melt_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY -- UNIQUE

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