[OSM-dev] osm2pgsql: super slow relations

Ramas ieskok at ramuno.lt
Wed Jul 18 06:54:34 BST 2012


fsync = off
synchronous_commit = on
autovacuum = off
checkpoint_segments = 30

PostgreSQL 9.1.4


On 17 July 2012 18:04, sly (sylvain letuffe) <liste at letuffe.org> wrote:

> Le mardi 17 juillet 2012 16:03:55, Ramas a écrit :
> > Hi,
> > after some updates in my system osm2pgsql relation processing in slim
> mode
> > become very slow:
>
> What's values are your
> fsync and synchronous_commit settings in postgresql.conf ?
>
> With fsync = on I've seen the same behaviour as yours, try turning it off
> to
> see if speed is increased ?
>
> --
> sly (sylvain letuffe)
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20120718/1fc6d37f/attachment.html>


More information about the dev mailing list