[taler-exchange] branch master updated: -add index on shard

[gnunet]

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

grothoff pushed a commit to branch master
in repository exchange.

The following commit(s) were added to refs/heads/master by this push:
     new 0cf46d8e -add index on shard
0cf46d8e is described below

commit 0cf46d8e5995f84a642795ddf214776ed8d4077f
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Mon Jan 9 19:35:16 2023 +0100

    -add index on shard
---
 src/exchangedb/0002-work_shards.sql | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/src/exchangedb/0002-work_shards.sql 
b/src/exchangedb/0002-work_shards.sql
index 016207d3..220745d4 100644
--- a/src/exchangedb/0002-work_shards.sql
+++ b/src/exchangedb/0002-work_shards.sql
@@ -49,3 +49,8 @@ CREATE INDEX work_shards_by_end_row_index
   ON work_shards
   (end_row DESC);
 
+CREATE INDEX work_shards_by_rows
+  ON work_shards
+  (job_name
+  ,start_row
+  ,end_row);

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