From 25a2e68cdf9eb1773b68c908b6afc9ff8081478b Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Wed, 25 Jul 2007 15:16:37 +0200 Subject: [PATCH 1/1] Allow more work_mem when upgrading. --- sql/upgrade-v2.50.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/upgrade-v2.50.sql b/sql/upgrade-v2.50.sql index 6f740fe..51bd757 100644 --- a/sql/upgrade-v2.50.sql +++ b/sql/upgrade-v2.50.sql @@ -1,6 +1,8 @@ -- -- Upgrades pre-v2.50 databases to 2.50 format -- not many changes, though. -- +SET work_mem=131072; + ALTER TABLE exif_info RENAME COLUMN tag TO key; CREATE INDEX exif_info_key ON exif_info ( key ); CLUSTER exif_info_key ON exif_info; -- 2.39.2