[OSM-dev] Planet file space requirements

[Linden Varley]

Is there potential to be able to do differential updates on a non-slim imported db?

Reason I ask is I have plenty of memory, but little DB space (SSD) and I would like to do weekly diffs, import with osm2pgsql and get a tile expiry list to re-cache changed tiles.

If not, I'll import with slim on a larger disk and do a filesystem copy across to the SSD.

- Linden

-----Original Message-----
From: Frederik Ramm [mailto:frederik at remote.org]
Sent: Tuesday, 27 October 2009 6:48 PM
To: Linden Varley
Cc: dev at openstreetmap.org
Subject: Re: [OSM-dev] Planet file space requirements

Hi,

Linden Varley wrote:
> I was just wondering what the space requirements were for loading the whole planet file. I have about ~50GB free and am running out of space when running osm2pgsql in slim mode.

Yes, you will need about 70 GB.

> Also does slim mode create extra tables which don't get created in normal mode? i.e planet_osm_nodes , planet_osm_ways, planet_osm_rels

Yes. You can save a lot of disk space and import time if you work
without --slim, however this requires at least 12 (?) GB of memory and
makes it impossible to do differential updates.

Bye
Frederik

--
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"

The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.