diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2022-03-19 14:05:45 +0100 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2022-03-19 14:05:45 +0100 |
commit | f5e5f4b843f09f9b68ea1998ce18b369ccbcccd7 (patch) | |
tree | 88494d966f0b2d435640cfddc4fa2b5442fb9dd3 /src/exchangedb/drop0001.sql | |
parent | f22125ce0fa074f0dbf090ccbbee3f119c94e619 (diff) | |
download | exchange-f5e5f4b843f09f9b68ea1998ce18b369ccbcccd7.tar.gz exchange-f5e5f4b843f09f9b68ea1998ce18b369ccbcccd7.tar.bz2 exchange-f5e5f4b843f09f9b68ea1998ce18b369ccbcccd7.zip |
more work on recoup_by_reserve: add new materialized index to avoid hitting all partitions for the query
Diffstat (limited to 'src/exchangedb/drop0001.sql')
-rw-r--r-- | src/exchangedb/drop0001.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/exchangedb/drop0001.sql b/src/exchangedb/drop0001.sql index aabfdb5e2..27595b819 100644 --- a/src/exchangedb/drop0001.sql +++ b/src/exchangedb/drop0001.sql @@ -31,6 +31,8 @@ DROP TRIGGER IF EXISTS reserves_out_on_insert ON reserves_out; DROP TRIGGER IF EXISTS reserves_out_on_delete ON reserves_out; DROP TRIGGER IF EXISTS deposits_on_insert ON deposits; DROP TRIGGER IF EXISTS deposits_on_delete ON deposits; +DROP TRIGGER IF EXISTS recoup_on_insert ON recoup; +DROP TRIGGER IF EXISTS recoup_on_delete ON recoup; DROP TABLE IF EXISTS revolving_work_shards CASCADE; DROP TABLE IF EXISTS extensions CASCADE; DROP TABLE IF EXISTS auditors CASCADE; |