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

Frederik Ramm frederik at remote.org
Mon Aug 8 23:00:42 BST 2011


Hi,

Stephan Knauss wrote:
> 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.

I don't understand. The intarray/no intarray question is completely 
unrelated to the fastupdate on/off question?

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"



More information about the dev mailing list