[OSM-dev] Postgres 8.4/PostGIS 1.4 performance
Martijn van Oosterhout
kleptog at gmail.com
Sat Sep 19 18:12:14 BST 2009
On Wed, Sep 16, 2009 at 9:39 PM, Martin Lesser <ml-osm-dev at 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
If you want timestamps, turn on log_min_duration_statement on your
server and check the logs for long running statements.
Have a nice day,
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/
More information about the dev