[OSM-dev] slow diff updates / FASTUPDATE / osm2pgsql bug
osm at stephans-server.de
Mon Aug 8 23:57:45 BST 2011
On 09.08.2011 00:00, Frederik Ramm wrote:
> Stephan Knauss wrote:
>> 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?
The problem was that the INDEX is different. It has the gin__int_ops
included on my installation with intarray in place.
USING gin (nodes gin__int_ops)
I guess without it postgres was not using indexes at all and thus
slowing it down that much.
More information about the dev