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
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
