[OSM-talk] OSM Postgres table sizes (was: Failed to download 9.5 GB planet)

[Juan Lucas Domínguez Rubio]

From: Richard Weait <richard at weait.com>
Subject:
 Re: [OSM-talk] OSM Postgres table sizes (was: Failed to download 9.5 GB
 planet)
To: talk at openstreetmap.org
Date: Thursday, June 24, 2010,
 4:28 PM

On Thu, Jun 24, 2010 at 4:34 AM, 
Juan Lucas Domínguez Rubio
<juan_lucas_dr at yahoo.com>
 wrote:
>
> Hello, thanks.
>
> Solved. I think 
the problem was that I was downloading the file to a remote disk (R: 
mapped to \\lanserver\data)
>
> Another question: after 
exporting the whole planet (recently) to Postgres, what is the size of 
the largest table created (which I presume will take up 80% of the whole
 DB)?

based on my planet and minutely mapnik:

8 GB polygon
21
 GB line
2 GB point
43 GB nodes
3 GB roads
50 GB ways
4 
GB rels

overall disk use ~ 130 GB and growing about 2.5 GB/week 
at the moment.

_______________________________________________
talk
 mailing list
talk at openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk


Hello, thanks.
That's much more than what I expected. With a small example, I obtained a 1:3 ratio between the .osm format and the table size, so I estimated ~50 GB for the whole DB.

Regards,
Juan Lucas





      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20100624/260846e8/attachment.html>