[OSM-dev] osm2pgsql patch mode very slow.

[Martijn van Oosterhout]

What version of postgres? Are you running the latest version from SVN?

On Wed, Sep 24, 2008 at 5:18 PM, Steve Hill <steve at nexusuk.org> wrote:
>
> I'm trying to use the new osm2pgsql patch mode - I've imported the
> whole of last Wednesday's planet using slim mode and I'm now trying to
> apply the first daily patch file.  However, it is *really* slow (the
> patching has been running for days for just a single day's diff).
>
> I'm seeing extremely long SQL queries logged by Postgres:
>
> LOG:  duration: 936198.972 ms  statement: EXECUTE <unnamed>  [PREPARE:
> PREPARE node_changed_mark(int4) AS UPDATE planet_osm_ways SET pending =
> true WHERE nodes @ ARRAY[$1] AND NOT pending;
>
> Could this be something as simple as a missing index, or is something more
> serious likely to be wrong?
>
>  - Steve
>    xmpp:steve at nexusuk.org   sip:steve at nexusuk.org   http://www.nexusuk.org/
>
>      Servatis a periculum, servatis a maleficum - Whisper, Evanescence
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>



-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/