From f5e5f4b843f09f9b68ea1998ce18b369ccbcccd7 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <grothoff@gnunet.org>
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

