[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-grid5k] 16/189: re-enable sharding of aggregation tracking tables
From: |
gnunet |
Subject: |
[taler-grid5k] 16/189: re-enable sharding of aggregation tracking tables |
Date: |
Thu, 28 Apr 2022 10:46:26 +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 7d17d575b936cffc9e11f7fd5f3c512598d2b744
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Mon Feb 21 17:27:02 2022 +0100
re-enable sharding of aggregation tracking tables
---
sql/exchange-0002.sql | 24 ++++++++++++------------
1 file changed, 12 insertions(+), 12 deletions(-)
diff --git a/sql/exchange-0002.sql b/sql/exchange-0002.sql
index 4576ba7..0fe46a6 100644
--- a/sql/exchange-0002.sql
+++ b/sql/exchange-0002.sql
@@ -17,8 +17,8 @@ BEGIN
ALTER TABLE IF EXISTS refresh_transfer_keys DETACH PARTITION
refresh_transfer_keys_default;
ALTER TABLE IF EXISTS deposits DETACH PARTITION deposits_default;
ALTER TABLE IF EXISTS refunds DETACH PARTITION refunds_default;
- -- ALTER TABLE IF EXISTS wire_out DETACH PARTITION wire_out_default;
- -- ALTER TABLE IF EXISTS aggregation_tracking DETACH PARTITION
aggregation_tracking_default;
+ ALTER TABLE IF EXISTS wire_out DETACH PARTITION wire_out_default;
+ ALTER TABLE IF EXISTS aggregation_tracking DETACH PARTITION
aggregation_tracking_default;
ALTER TABLE IF EXISTS recoup DETACH PARTITION recoup_default;
ALTER TABLE IF EXISTS recoup_refresh DETACH PARTITION recoup_refresh_default;
ALTER TABLE IF EXISTS prewire DETACH PARTITION prewire_default;
@@ -44,8 +44,8 @@ BEGIN
DROP TABLE IF EXISTS refresh_transfer_keys_default;
DROP TABLE IF EXISTS deposits_default;
DROP TABLE IF EXISTS refunds_default;
- -- DROP TABLE IF EXISTS wire_out_default;
- -- DROP TABLE IF EXISTS aggregation_tracking_default;
+ DROP TABLE IF EXISTS wire_out_default;
+ DROP TABLE IF EXISTS aggregation_tracking_default;
DROP TABLE IF EXISTS recoup_default;
DROP TABLE IF EXISTS recoup_refresh_default;
DROP TABLE IF EXISTS prewire_default;
@@ -104,8 +104,8 @@ BEGIN
PERFORM create_partition('refresh_transfer_keys', modulus, num_partitions);
PERFORM create_partition('deposits', modulus, num_partitions);
PERFORM create_partition('refunds', modulus, num_partitions);
- -- PERFORM create_partition('wire_out', modulus, num_partitions);
- -- PERFORM create_partition('aggregation_tracking', modulus,
num_partitions);
+ PERFORM create_partition('wire_out', modulus, num_partitions);
+ PERFORM create_partition('aggregation_tracking', modulus, num_partitions);
PERFORM create_partition('recoup', modulus, num_partitions);
PERFORM create_partition('recoup_refresh', modulus, num_partitions);
PERFORM create_partition('prewire', modulus, num_partitions);
@@ -188,11 +188,11 @@ BEGIN
ALTER TABLE IF EXISTS refunds DROP CONSTRAINT IF EXISTS refunds_pkey CASCADE;
- -- ALTER TABLE IF EXISTS wire_out DROP CONSTRAINT IF EXISTS wire_out_pkey
CASCADE;
- -- ALTER TABLE IF EXISTS wire_out DROP CONSTRAINT IF EXISTS
wire_out_wtid_raw_key CASCADE;
+ ALTER TABLE IF EXISTS wire_out DROP CONSTRAINT IF EXISTS wire_out_pkey
CASCADE;
+ ALTER TABLE IF EXISTS wire_out DROP CONSTRAINT IF EXISTS
wire_out_wtid_raw_key CASCADE;
- -- ALTER TABLE IF EXISTS aggregation_tracking DROP CONSTRAINT IF EXISTS
aggregation_tracking_pkey CASCADE;
- -- ALTER TABLE IF EXISTS aggregation_tracking DROP CONSTRAINT IF EXISTS
aggregation_tracking_wtid_raw_fkey;
+ ALTER TABLE IF EXISTS aggregation_tracking DROP CONSTRAINT IF EXISTS
aggregation_tracking_pkey CASCADE;
+ ALTER TABLE IF EXISTS aggregation_tracking DROP CONSTRAINT IF EXISTS
aggregation_tracking_wtid_raw_fkey;
ALTER TABLE IF EXISTS recoup DROP CONSTRAINT IF EXISTS recoup_pkey CASCADE;
@@ -248,8 +248,8 @@ BEGIN
PERFORM create_foreign_table('refresh_transfer_keys', num_shards, suffix,
shard_idx);
PERFORM create_foreign_table('deposits', num_shards, suffix, shard_idx);
PERFORM create_foreign_table('refunds', num_shards, suffix, shard_idx);
- -- PERFORM create_foreign_table('wire_out', num_shards, suffix, shard_idx);
- -- PERFORM create_foreign_table('aggregation_tracking', num_shards, suffix,
shard_idx);
+ PERFORM create_foreign_table('wire_out', num_shards, suffix, shard_idx);
+ PERFORM create_foreign_table('aggregation_tracking', num_shards, suffix,
shard_idx);
PERFORM create_foreign_table('recoup', num_shards, suffix, shard_idx);
PERFORM create_foreign_table('recoup_refresh', num_shards, suffix,
shard_idx);
PERFORM create_foreign_table('prewire', num_shards, suffix, shard_idx);
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
- [taler-grid5k] 179/189: fix tar path of centos, (continued)
- [taler-grid5k] 179/189: fix tar path of centos, gnunet, 2022/04/28
- [taler-grid5k] 181/189: centos database working, gnunet, 2022/04/28
- [taler-grid5k] 140/189: move loki data to nfs directly as lost in copy, gnunet, 2022/04/28
- [taler-grid5k] 126/189: try further with promtail metrics, gnunet, 2022/04/28
- [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 <=
- [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, 2022/04/28
- [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