diff options
Diffstat (limited to 'util/updates/update_2.26.sql')
-rw-r--r-- | util/updates/update_2.26.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/util/updates/update_2.26.sql b/util/updates/update_2.26.sql index 20293878..b73936ad 100644 --- a/util/updates/update_2.26.sql +++ b/util/updates/update_2.26.sql @@ -48,3 +48,9 @@ $$ LANGUAGE SQL; -- Thai language ALTER TYPE language ADD VALUE 'th' BEFORE 'tr'; + + +-- Improve performance for traits_chars calculation +ALTER TABLE traits_chars DROP CONSTRAINT traits_chars_cid_fkey; +ALTER TABLE traits_chars DROP CONSTRAINT traits_chars_tid_fkey; +CREATE INDEX traits_chars_tid ON traits_chars (tid); |