[OSM-dev] slow diff updates / FASTUPDATE / osm2pgsql bug

Stephan Knauss osm at stephans-server.de
Mon Aug 8 21:47:56 BST 2011


On 07.08.2011 21:19, Frederik Ramm wrote:
> To be a bit clearer on the procedure to fix things: Either re-import, or
> re-create indexes with
>
> DROP INDEX planet_osm_ways_nodes;
> DROP INDEX planet_osm_rels_parts;
> CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes)
> WITH (fastupdate=off);
> CREATE INDEX planet_osm_rels_parts ON planet_osm_rels USING gin (parts)
> WITH (fastupdate=off);

This did lead to huge problems on my DB as it was still using the 
intarray for the updates.

Recovered it with the gin__int_ops on the gin index:

DROP INDEX planet_osm_ways_nodes;
DROP INDEX planet_osm_rels_parts;
CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes 
gin__int_ops)
WITH (fastupdate=off);
CREATE INDEX planet_osm_rels_parts ON planet_osm_rels USING gin (parts 
gin__int_ops)
WITH (fastupdate=off);


Documentation suggests to use ALTER INDEX instead. I did not try it as I 
already broke my DB using the original commands.


Stephan



More information about the dev mailing list