[OSM-talk] Size of installed Database?

[Lynn W. Deffenbaugh (Mr)]

I have my full planet database coupled with the flatnodes file on a pair 
of SSDs.  One is 128GB and the other is 256GB and they're VERY close to 
not being large enough. I've got the rendering tables on one and the 
update (forget the proper names) tables on the other.  I'm looking to 
swap out the 128GB with a 256GB and hopefully split the rendering tables 
between the spindles with the corresponding update tables on the 
opposite spindle.

Munin (http://tinyurl.com/6v8lvvc) shows my gis database at 272GB, but 
that doesn't include the 18GB flatnodes file (that's growing steadily) 
for a total consumption of 290GB.

Lynn (D) - KJ4ERJ - Author of APRSISCE for Windows Mobile and Win32

On 8/31/2013 1:58 PM, TorstenMohr at schleim wrote:
> Hello,
>
> i'm about to install the latest planet.osm and i'd like to install it on an
> SSD.
>
> The bzipped XML file is approximately 31 GB of size, but how much space will i
> need on an SSD for the PostgreSQL database?
>
> I haven't bought an SSD yet and i'd like to make sure that the database will
> fit on the SSD.
>
>
> It would be very kind if somebody could tell me how much size an installation
> takes on disk and how old their installation is (if it is not actual).
>
>
> Thanks for any hints
> Torsten
>
>
> _______________________________________________
> talk mailing list
> talk at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
>