From f5e5f4b843f09f9b68ea1998ce18b369ccbcccd7 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Sat, 19 Mar 2022 14:05:45 +0100 Subject: more work on recoup_by_reserve: add new materialized index to avoid hitting all partitions for the query --- src/exchangedb/drop0001.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'src/exchangedb/drop0001.sql') diff --git a/src/exchangedb/drop0001.sql b/src/exchangedb/drop0001.sql index aabfdb5e..27595b81 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; -- cgit v1.2.3