From bd40827b737464ea2de8857fded057122543990a Mon Sep 17 00:00:00 2001 From: Anders Kaseorg Date: Thu, 18 Dec 2014 02:18:17 -0500 Subject: Drop duplicate database indexes These duplicate indexes were found by the pt-duplicate-key-checker tool in percona-toolkit. Duplicate indexes waste space and slow down the query planner. Closes #835. Signed-off-by: Anders Kaseorg --- schema/versions/pgsql/127.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 schema/versions/pgsql/127.sql (limited to 'schema/versions/pgsql') diff --git a/schema/versions/pgsql/127.sql b/schema/versions/pgsql/127.sql new file mode 100644 index 000000000..7895aacc0 --- /dev/null +++ b/schema/versions/pgsql/127.sql @@ -0,0 +1,8 @@ +BEGIN; + +DROP INDEX ttrss_entries_guid_index; +DROP INDEX ttrss_prefs_pref_name_idx; + +UPDATE ttrss_version SET schema_version = 127; + +COMMIT; -- cgit v1.2.3