diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/update_2.15.sql | 3 |
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); + |