From: Sarah Hoffmann Date: Tue, 9 Oct 2012 20:29:16 +0000 (+0200) Subject: leave osm2pgsql tables on ssd X-Git-Tag: deploy~669 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/1bcc40b1e5e20006f32b3889e14d4867e8df84a2?ds=inline;hp=-c leave osm2pgsql tables on ssd --- 1bcc40b1e5e20006f32b3889e14d4867e8df84a2 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'); }