projects
/
pr0n
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(from parent 1:
42d4fc8
)
Allow more work_mem when upgrading.
author
Steinar H. Gunderson
<sesse@debian.org>
Wed, 25 Jul 2007 13:16:37 +0000
(15:16 +0200)
committer
Steinar H. Gunderson
<sesse@debian.org>
Wed, 25 Jul 2007 13:16:37 +0000
(15:16 +0200)
sql/upgrade-v2.50.sql
patch
|
blob
|
history
diff --git
a/sql/upgrade-v2.50.sql
b/sql/upgrade-v2.50.sql
index 6f740febde0a5aa1e87dc424a866a9976527c339..51bd75753bfceb82212434f4483d2956bff13508 100644
(file)
--- 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;