[mb-commits] branch, mbs-5767, created. MBS-5767: Add an index on (editor, id DESC)

The branch, mbs-5767 has been created
        at  ce4ae81b306abe97d97382b6f11ea484fd3018e8 (commit)

- Log -----------------------------------------------------------------
commit ce4ae81b306abe97d97382b6f11ea484fd3018e8
Author: Oliver Charles <[email protected]>
Date:   Tue Jan 22 10:27:56 2013 +0000

    MBS-5767: Add an index on (editor, id DESC)
    
    This allows /user/:user/edits to load without timing out.

diff --git a/admin/sql/CreateIndexes.sql b/admin/sql/CreateIndexes.sql
index cb5c654..f9a059a 100644
--- a/admin/sql/CreateIndexes.sql
+++ b/admin/sql/CreateIndexes.sql
@@ -53,6 +53,9 @@ CREATE INDEX edit_idx_status ON edit (status) WHERE status != 2;
 CREATE INDEX edit_artist_idx_status ON edit_artist (status);
 CREATE INDEX edit_label_idx_status ON edit_label (status);
 
+-- Index for viewing the latest edits for users
+CREATE INDEX edit_idx_editor_id_desc ON edit (editor, id DESC);
+
 CREATE INDEX edit_open_time_date ON edit (date_trunc('day', open_time AT TIME ZONE 'UTC'));
 CREATE INDEX edit_close_time_date ON edit (date_trunc('day', close_time AT TIME ZONE 'UTC'));
 CREATE INDEX edit_expire_time_date ON edit (date_trunc('day', expire_time AT TIME ZONE 'UTC'));
diff --git a/admin/sql/DropIndexes.sql b/admin/sql/DropIndexes.sql
index f516a76..8e533ae 100644
--- a/admin/sql/DropIndexes.sql
+++ b/admin/sql/DropIndexes.sql
@@ -29,6 +29,7 @@ DROP INDEX edit_artist_idx_status;
 DROP INDEX edit_close_time_date;
 DROP INDEX edit_expire_time_date;
 DROP INDEX edit_idx_editor;
+DROP INDEX edit_idx_editor_id_desc;
 DROP INDEX edit_idx_open_time;
 DROP INDEX edit_idx_status;
 DROP INDEX edit_idx_type;

-----------------------------------------------------------------------


hooks/post-receive
-- 
mb_server