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

[Stephan Knauss]

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.

Stephan