[PERFORM] long running insert statement

2009-10-01 Thread Gerd König
Hello, we're currently facing long running insert statements with durations ~15sec (far too long...) and I've no idea what's the reason for this issue. An "explain analyze" of the insert statement tells me: SNIP # begin; BEGIN t

Re: [PERFORM] long running insert statement

2009-10-01 Thread Gerd König
; > I agree with Matthew's solution --- an index better adapted to this > query will probably be worth its maintenance overhead. But if you > want to understand the behavior you were seeing in trying to > investigate, I think it's one of the two issues above. > >