liquid_feedback_core

changeset 592:332a2177e208

Reduced indices on "issue" table
author jbe
date Sat Dec 08 01:26:25 2018 +0100 (19 months ago)
parents d955519f7471
children e7f772ca0621
files core.sql
line diff
     1.1 --- a/core.sql	Fri Dec 07 17:49:53 2018 +0100
     1.2 +++ b/core.sql	Sat Dec 08 01:26:25 2018 +0100
     1.3 @@ -866,12 +866,8 @@
     1.4            ("fully_frozen" ISNULL OR "full_freeze_snapshot_id" NOTNULL) ) );
     1.5  CREATE INDEX "issue_state_idx" ON "issue" ("state");
     1.6  CREATE INDEX "issue_created_idx" ON "issue" ("created");
     1.7 -CREATE INDEX "issue_accepted_idx" ON "issue" ("accepted");
     1.8 -CREATE INDEX "issue_half_frozen_idx" ON "issue" ("half_frozen");
     1.9 -CREATE INDEX "issue_fully_frozen_idx" ON "issue" ("fully_frozen");
    1.10  CREATE INDEX "issue_closed_idx" ON "issue" ("closed");
    1.11 -CREATE INDEX "issue_created_idx_open" ON "issue" ("created") WHERE "closed" ISNULL;
    1.12 -CREATE INDEX "issue_closed_idx_canceled" ON "issue" ("closed") WHERE "fully_frozen" ISNULL;
    1.13 +CREATE INDEX "issue_open_created_idx" ON "issue" ("created") WHERE "closed" ISNULL;
    1.14  CREATE INDEX "issue_latest_snapshot_id_idx" ON "issue" ("latest_snapshot_id");
    1.15  CREATE INDEX "issue_admission_snapshot_id_idx" ON "issue" ("admission_snapshot_id");
    1.16  CREATE INDEX "issue_half_freeze_snapshot_id_idx" ON "issue" ("half_freeze_snapshot_id");

Impressum / About Us