X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fupgrade-v3.11.sql;h=94884d8dcc64eef373b78101f5e7076f1f97f0ea;hp=7996fead4ea8a3143058b31e2523c9064ce7c5ea;hb=8e5ec72d5a96e0828d61cd74d27cfa3725d337db;hpb=6c8c4bf3f1e3109523f9ec6117abfdf0e04a0d99

diff --git a/sql/upgrade-v3.11.sql b/sql/upgrade-v3.11.sql
index 7996fea..94884d8 100644
--- a/sql/upgrade-v3.11.sql
+++ b/sql/upgrade-v3.11.sql
@@ -1,3 +1,5 @@
+set work_mem to 1048576;
+
 alter table images add column is_render boolean NOT NULL DEFAULT false;
 alter table images add column render_id integer;
 CREATE UNIQUE INDEX unique_id_for_render ON images USING btree (vhost, event, id);
@@ -6,3 +8,7 @@ alter table images add check (NOT (is_render AND (render_id IS NOT NULL)));
 
 alter table deleted_images add column is_render boolean NOT NULL DEFAULT false;
 alter table deleted_images add column render_id integer;
+
+drop index exif_info_key;
+alter table exif_info drop constraint exif_info_pkey;
+alter table exif_info add primary key ( image, key );