diff options
author | Anders Kaseorg <[email protected]> | 2014-12-18 02:18:17 -0500 |
---|---|---|
committer | Anders Kaseorg <[email protected]> | 2014-12-18 02:50:03 -0500 |
commit | bd40827b737464ea2de8857fded057122543990a (patch) | |
tree | 1efc20f5cd26aaf8e0e3566db69efef90c742410 /schema/versions/pgsql/127.sql | |
parent | d8895ec679fb3557ddf01d8be74a5eb82c7dac7a (diff) |
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 <[email protected]>
Diffstat (limited to 'schema/versions/pgsql/127.sql')
-rw-r--r-- | schema/versions/pgsql/127.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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; |