summaryrefslogtreecommitdiff
path: root/db/08to09_pg.sql
diff options
context:
space:
mode:
authorBrion Vibber <brion@pobox.com>2009-11-12 11:08:43 -0800
committerBrion Vibber <brion@pobox.com>2009-11-12 11:08:43 -0800
commit81fa515881e42afe55379befa4e7d93313c90891 (patch)
treeb5d16054787cb85f64488ec647decd503e3f4306 /db/08to09_pg.sql
parentd8fe5224cb5628f1a281c7498a516e89992f6474 (diff)
Fix index on notice for efficient querying of notice(s) by order for a profile.
Should resolve performance problem with Profile::getCurrentNotice()
Diffstat (limited to 'db/08to09_pg.sql')
-rw-r--r--db/08to09_pg.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql
index 004c77b36..fe9eccb2a 100644
--- a/db/08to09_pg.sql
+++ b/db/08to09_pg.sql
@@ -57,3 +57,7 @@ alter table subscription
add index subscription_subscriber_idx using btree(subscriber,created),
drop index subscription_subscribed_idx,
add index subscription_subscribed_idx using btree(subscribed,created);
+
+alter table notice
+ drop index notice_profile_id_idx,
+ add index notice_profile_id_idx using btree(profile_id,created,id);