summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.15.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/util/updates/update_2.15.sql b/util/updates/update_2.15.sql
index b35b7636..75961785 100644
--- a/util/updates/update_2.15.sql
+++ b/util/updates/update_2.15.sql
@@ -2,3 +2,6 @@
ALTER TABLE tags_vn ADD COLUMN date timestamptz NOT NULL DEFAULT NOW();
+-- this index is essential, quite often sorted on
+CREATE INDEX tags_vn_date ON tags_vn (date);
+