On Sat, Sep 19, 2009 at 07:12:14PM +0200, Martijn van Oosterhout wrote: > On Wed, Sep 16, 2009 at 9:39 PM, Martin Lesser <ml-osm-...@bettercom.de> > wrote: > >> Can anybody confirm this measurement, or even suggest what the reason > >> might be? > > > > Another pointer: How many VACUUMs does osm2pgsql trigger during import > > and filling the own tables? > > None, AFAICS from the source. That's what autovacuum is for. It does > analyse each table. > > (I beleive it used to vacuum, but I don't immediately see it in the > current source).
I always disabled autovacuum for this kind of database. It tends to always come at the wrong time. Its better to do the vacuum once after an import run and never in between. Autovacuum is nice for a database where many different programs change data all the time. For a OSM Mapnik database where there is exactly one program changing data, it should do the vacuum itself. Jochen -- Jochen Topf joc...@remote.org http://www.remote.org/jochen/ +49-721-388298 _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev