[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-grid5k] 38/189: test
From: |
gnunet |
Subject: |
[taler-grid5k] 38/189: test |
Date: |
Thu, 28 Apr 2022 10:46:48 +0200 |
This is an automated email from the git hooks/post-receive script.
marco-boss pushed a commit to branch master
in repository grid5k.
commit c31c8d16dcbd6126bd0c8d7c2dfac028aea56e98
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Sun Feb 27 17:25:18 2022 +0100
test
---
sql/exchange-0001.sql | 9 +++++----
1 file changed, 5 insertions(+), 4 deletions(-)
diff --git a/sql/exchange-0001.sql b/sql/exchange-0001.sql
index 184d62a..b65422f 100644
--- a/sql/exchange-0001.sql
+++ b/sql/exchange-0001.sql
@@ -67,13 +67,13 @@ COMMENT ON TABLE denomination_revocations
CREATE TABLE IF NOT EXISTS wire_targets
- (wire_target_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY -- UNIQUE
- ,h_payto BYTEA PRIMARY KEY CHECK (LENGTH(h_payto)=64)
+ (wire_target_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
+ ,h_payto BYTEA CHECK (LENGTH(h_payto)=64)
,payto_uri VARCHAR NOT NULL
,kyc_ok BOOLEAN NOT NULL DEFAULT (FALSE)
,external_id VARCHAR
)
- PARTITION BY HASH (h_payto);
+ PARTITION BY HASH (wire_target_serial_id);
COMMENT ON TABLE wire_targets
IS 'All senders and recipients of money via the exchange';
COMMENT ON COLUMN wire_targets.payto_uri
@@ -91,9 +91,10 @@ CREATE TABLE IF NOT EXISTS wire_targets_default
-- FIXME partition by serial_id rather than h_payto,
-- it is used more in join conditions - crucial for sharding to select this.
-- Author: (Boss Marco)
-CREATE INDEX IF NOT EXISTS wire_targets_serial_id_index
+CREATE INDEX IF NOT EXISTS wire_targets_serial_payto_index
ON wire_targets
(wire_target_serial_id
+ ,h_payto
);
CREATE TABLE IF NOT EXISTS reserves
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
- [taler-grid5k] 27/189: include shards in monitoring, (continued)
- [taler-grid5k] 27/189: include shards in monitoring, gnunet, 2022/04/28
- [taler-grid5k] 24/189: fix missing with tar, gnunet, 2022/04/28
- [taler-grid5k] 42/189: hopefully better logging of slow queries with pg_stat_statements, gnunet, 2022/04/28
- [taler-grid5k] 39/189: test do not partition wire_targets, gnunet, 2022/04/28
- [taler-grid5k] 14/189: aggregation tracking cant be sharded, gnunet, 2022/04/28
- [taler-grid5k] 30/189: log nested statements to hopefully get function debug output, gnunet, 2022/04/28
- [taler-grid5k] 16/189: re-enable sharding of aggregation tracking tables, gnunet, 2022/04/28
- [taler-grid5k] 43/189: again without analyze, gnunet, 2022/04/28
- [taler-grid5k] 47/189: add monitor to dahu because of link speed, gnunet, 2022/04/28
- [taler-grid5k] 20/189: fix typos, gnunet, 2022/04/28
- [taler-grid5k] 38/189: test,
gnunet <=
- [taler-grid5k] 106/189: viualizer can parse log lines / formatted output, gnunet, 2022/04/28
- [taler-grid5k] 21/189: generic wire-fee year, fix empty shards when partitioned only, gnunet, 2022/04/28
- [taler-grid5k] 90/189: add doc, gnunet, 2022/04/28
- [taler-grid5k] 77/189: test custom metrics, gnunet, 2022/04/28
- [taler-grid5k] 116/189: fix verbose output, gnunet, 2022/04/28
- [taler-grid5k] 124/189: enable admin api for prometheus in order to test snapshots, gnunet, 2022/04/28
- [taler-grid5k] 75/189: also separate wallet from the main syslog receiver, gnunet, 2022/04/28
- [taler-grid5k] 80/189: change denominations, gnunet, 2022/04/28
- [taler-grid5k] 62/189: fix lookahead sign, gnunet, 2022/04/28
- [taler-grid5k] 84/189: cleaner exchange setup, gnunet, 2022/04/28