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

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

Stephan



More information about the dev mailing list