On 24/06/10 19:44, John Smith wrote: > On 25 June 2010 04:37, Richard Weait <rich...@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 _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk