[OSM-dev] size of apidb

Grant Slater openstreetmap at firefishy.com
Fri Aug 27 21:59:34 BST 2010


On 27 August 2010 19:50, Marco Lechner - FOSSGIS e.V.
<marco.lechner at fossgis.de> wrote:
> Munin reports about 1.2 TB fot the whole Api-DB.
> If I calculate the size of the full-history-dump (unpacked about 338 GB)
> and add the size of the planet-file (unpacked about 155 GB) for the
> current_tables I get a sum of less the 500 GB. Let's add some GB for
> Indexes and things like email-adresses and passwords of the users.
> How can the ApiDB be about twice the size? Of course it's not o.k to
> compare a file with a relational database, but comparing the DB with a
> space-wasting XML-file?
>
> I'm confused and asking for enlightenment.
>

You are forgetting about the GPS/GPX points table.

The compressed raw GPX files total 193GB.

Regards
 Grant



More information about the dev mailing list