[OSM-talk] OSM Postgres table sizes

[Chris Jones]

On 24/06/10 19:44, John Smith wrote:
> On 25 June 2010 04:37, Richard Weait <richard at weait.com> wrote:
>   
>> I'm not sure I understand your question.
>>     
> Over time, the overhead increases, not just the amount of data.
>   
>> lose some large tables.  But then you lose the ability to update
>> unless you do a re-import.
>>     
> That's my question, how to eliminate overhead in the database without
> re-importing.
>   

Any overhead is typically a percentage of the stored data for indexes
and such, you cant just magically get rid of it!

What you can do is vacuum the database to reorganise the on disk storage
at intervals, but I would suspect that's already happening.

--
Chris Jones, SUCS Admin
http://sucs.org