<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
<br>
I'd like to inquire about the estimated disk size needed to import
the planet osm file into PostGIS?<br>
<br>
<br>
What I wanted to do is to import planet osm into a PostGIS that is
based on a 512GB SSD (well, formatted and reported size: 459G,
480720592 bytes). I did the import using osm2pgsql, using:<br>
<br>
/usr/local/bin/osm2pgsql -d osm_world -s -C 5800 --hstore-all -K -v
-G -m planet-130620.osm.bz2<br>
<br>
<br>
the end of the import is the following:<br>
<br>
Completed planet_osm_roads<br>
Creating osm_id index on planet_osm_point<br>
Creating indexes on planet_osm_point finished<br>
All indexes on planet_osm_point created in 10171s<br>
Completed planet_osm_point<br>
CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin
(nodes) WITH (FASTUPDATE=OFF);<br>
failed: ERROR: could not extend file "base/1602600/4948340.12": No
space left on device<br>
HINT: Check free disk space.<br>
<br>
Error occurred, cleaning up<br>
<br>
<br>
<br>
<br>
of course I have more space on traditional HDDs, but my main point
is to have the I/O intensive parts of the PostGIS database on the
SSD. the OSM file to be imported is located on a traditional HDD
(not on the SSD), and the osm2pgsql command is also issued from a
prompt that resides on the HDD. the /tmp directory is not on the SSD
either.<br>
<br>
the SSD is formatted as ext4<br>
<br>
would the planet OSM in general fit on such a disk?<br>
<br>
are there optimization possibilities to decrease the required disk
size for the import? maybe:<br>
<ul>
<li>some temporary disk space is used during the import that could
be moved from the SSD to the HDD?</li>
<li>some not I/O specific parts of the database files could be
relocated to the HDD (and symlinked)?</li>
<li>some parts of the database could be omitted (like, I don't
need the history, etc.)</li>
<li>maybe some tune2fs magic?<br>
</li>
</ul>
<p><br>
any pointers, ideas, etc. welcome,<br>
</p>
<p><br>
Akos<br>
<br>
</p>
</body>
</html>