<div dir="ltr">it depends on the schema and a couple of options like hstore:<div>- osm2pgsql "mapnik" schema without hstore is less than 300GB : <a href="http://munin.openstreetmap.org/openstreetmap/yevaud.openstreetmap/postgres_size_gis_9_1_main.html">http://munin.openstreetmap.org/openstreetmap/yevaud.openstreetmap/postgres_size_gis_9_1_main.html</a></div>
<div>- osm2pgsql "mapnik" schema + hstore is above 300GB: <a href="http://munin.openstreetmap.fr/free.org/osm13.openstreetmap.fr/postgres_size_ALL.html">http://munin.openstreetmap.fr/free.org/osm13.openstreetmap.fr/postgres_size_ALL.html</a></div>
<div><br></div><div>- osm2pgsql for nominatim looks around 1TB as seen on <a href="http://munin.openstreetmap.org/openstreetmap/poldi.openstreetmap/postgres_size_nominatim_9_1_main.html">http://munin.openstreetmap.org/openstreetmap/poldi.openstreetmap/postgres_size_nominatim_9_1_main.html</a></div>
<div><br></div><div>These graphs also show the rate at which storage need in increasing... </div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/8/31 <span dir="ltr"><<a href="mailto:TorstenMohr@schleim" target="_blank">TorstenMohr@schleim</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
i'm about to install the latest planet.osm and i'd like to install it on an<br>
SSD.<br>
<br>
The bzipped XML file is approximately 31 GB of size, but how much space will i<br>
need on an SSD for the PostgreSQL database?<br>
<br>
I haven't bought an SSD yet and i'd like to make sure that the database will<br>
fit on the SSD.<br>
<br>
<br>
It would be very kind if somebody could tell me how much size an installation<br>
takes on disk and how old their installation is (if it is not actual).<br>
<br>
<br>
Thanks for any hints<br>
Torsten<br>
<br>
<br>
_______________________________________________<br>
talk mailing list<br>
<a href="mailto:talk@openstreetmap.org">talk@openstreetmap.org</a><br>
<a href="http://lists.openstreetmap.org/listinfo/talk" target="_blank">http://lists.openstreetmap.org/listinfo/talk</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Christian Quest - OpenStreetMap France<br>Un nouveau serveur pour OSM... <a href="http://donate.osm.org/server2013/" target="_blank">http://donate.osm.org/server2013/</a>
</div>