[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