From 48d08a4ddad16bdce6e4cf1b153c21efeb2cd6c8 Mon Sep 17 00:00:00 2001 From: Fournier Nicolas Date: Fri, 31 Jul 2015 15:49:40 +0200 Subject: index for reserves table --- src/mintdb/plugin_mintdb_postgres.c | 3 +++ 1 file changed, 3 insertions(+) (limited to 'src/mintdb/plugin_mintdb_postgres.c') diff --git a/src/mintdb/plugin_mintdb_postgres.c b/src/mintdb/plugin_mintdb_postgres.c index 20d65bc92..163420b2e 100644 --- a/src/mintdb/plugin_mintdb_postgres.c +++ b/src/mintdb/plugin_mintdb_postgres.c @@ -244,6 +244,9 @@ postgres_create_tables (void *cls, ",current_balance_curr VARCHAR("TALER_CURRENCY_LEN_STR") NOT NULL" ",expiration_date INT8 NOT NULL" ")"); + /* index on reserves table */ + SQLEXEC_INDEX ("CREATE INDEX reserves_reserve_pub_index ON " + "reserves (reserve_pub)"); /* reserves_in table collects the transactions which transfer funds into the reserve. The rows of this table correspond to each incoming transaction. */ -- cgit v1.2.3