diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2023-10-17 10:52:06 +0200 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2023-10-17 10:52:06 +0200 |
commit | 9294f3663712dbc60da1dc575278b47e9e56c6fa (patch) | |
tree | 8de62995b149a2136500c2bcdea017dfdfdfc1fc /src/exchangedb/0002-reserves_in.sql | |
parent | c190a1cdfce1cdecfcc25fd851f53e853377d5a9 (diff) | |
download | exchange-9294f3663712dbc60da1dc575278b47e9e56c6fa.tar.xz |
-remove dead index, add comment on live index
Diffstat (limited to 'src/exchangedb/0002-reserves_in.sql')
-rw-r--r-- | src/exchangedb/0002-reserves_in.sql | 16 |
1 files changed, 6 insertions, 10 deletions
diff --git a/src/exchangedb/0002-reserves_in.sql b/src/exchangedb/0002-reserves_in.sql index 1dfc5db69..197a815b3 100644 --- a/src/exchangedb/0002-reserves_in.sql +++ b/src/exchangedb/0002-reserves_in.sql @@ -83,22 +83,18 @@ BEGIN 'ON ' || table_name || ' ' '(reserve_in_serial_id);' ); - -- FIXME: where do we need this index? Can we do better? - EXECUTE FORMAT ( - 'CREATE INDEX ' || table_name || '_by_exch_accnt_section_execution_date_idx ' - 'ON ' || table_name || ' ' - '(exchange_account_section ' - ',execution_date' - ');' - ); - -- FIXME: where do we need this index? Can we do better? EXECUTE FORMAT ( 'CREATE INDEX ' || table_name || '_by_exch_accnt_reserve_in_serial_id_idx ' 'ON ' || table_name || ' ' '(exchange_account_section' - ',reserve_in_serial_id DESC' + ',reserve_in_serial_id ASC' ');' ); + EXECUTE FORMAT ( + 'COMMENT ON INDEX ' || table_name || '_by_exch_accnt_reserve_in_serial_id_idx ' + 'IS ' || quote_literal ('for pg_select_reserves_in_above_serial_id_by_account') || ';' + ); + END $$; |