From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 16 Aug 2012 19:34:48 +0000 (+0200)
Subject: keep slim tables in ssd for osm2pgsql
X-Git-Tag: deploy~685
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/03873df21182ee9a87f168f6108d93187db0c83e?ds=sidebyside

keep slim tables in ssd for osm2pgsql
---

diff --git a/sql/indices.src.sql b/sql/indices.src.sql
index 2e5dde71..fe42a7c3 100644
--- a/sql/indices.src.sql
+++ b/sql/indices.src.sql
@@ -1,3 +1,9 @@
+-- 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 663a9694..989e9887 100755
--- a/utils/setup.php
+++ b/utils/setup.php
@@ -126,7 +126,7 @@
 			echo "Please download and build osm2pgsql.\nIf it is already installed, check the path in your local settings (settings/local.php) file.\n";
 			fail("osm2pgsql not found in '$osm2pgsql'");
 		}
-		$osm2pgsql .= ' --tablespace-slim-index ssd --tablespace-main-index ssd --tablespace-main-data ssd --tablespace-slim-data ssd';
+		$osm2pgsql .= ' --tablespace-slim-index ssd --tablespace-main-index ssd --tablespace-main-data ssd --tablespace-slim-data data';
 		$osm2pgsql .= ' -lsc -O gazetteer --hstore';
 		$osm2pgsql .= ' -C 16000';
 		$osm2pgsql .= ' -d '.$aDSNInfo['database'].' '.$aCMDResult['osm-file'];
@@ -321,6 +321,7 @@
 			echo '.';
 		}
 		echo "\n";
+		pgsqlRunScript('ALTER TABLE place SET TABLESPACE "data"');
 		echo "Reanalysing database...\n";
 		pgsqlRunScript('ANALYSE');
 	}