From 1bcc40b1e5e20006f32b3889e14d4867e8df84a2 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 9 Oct 2012 22:29:16 +0200 Subject: [PATCH] leave osm2pgsql tables on ssd --- sql/indices.src.sql | 6 ------ utils/setup.php | 1 - 2 files changed, 7 deletions(-) diff --git a/sql/indices.src.sql b/sql/indices.src.sql index fe42a7c3..2e5dde71 100644 --- a/sql/indices.src.sql +++ b/sql/indices.src.sql @@ -1,9 +1,3 @@ --- osm2pgsql slim tables were on SSD just to speed up the import --- move them back to normal space -ALTER INDEX planet_osm_nodes_pkey SET TABLESPACE "data"; -ALTER INDEX planet_osm_ways_nodes SET TABLESPACE "data"; -ALTER INDEX planet_osm_rels_parts SET TABLESPACE "data"; - -- Indices used only during search and update. -- These indices are created only after the indexing process is done. diff --git a/utils/setup.php b/utils/setup.php index b5d6767d..8d5c6e39 100755 --- a/utils/setup.php +++ b/utils/setup.php @@ -342,7 +342,6 @@ echo '.'; } echo "\n"; - pgsqlRunScript('ALTER TABLE place SET TABLESPACE "data"'); echo "Reanalysing database...\n"; pgsqlRunScript('ANALYSE'); } -- 2.39.5