[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
current source).

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 mailing list