Theo Schlossnagle <[EMAIL PROTECTED]> writes:

> But the interesting thing is that there were 4.6 million elements in the
> s->childXids list.  Which is why it took so damn long.  I can't  quite figure
> out how I induced this state.  It is an OLAP server with  about 10-20
> connection that run "long" queries (from 5 seconds to 24  hours).

Wow, I think that means you've had 4.6 million subtransactions within the
current transaction. Is this a PL/PgSQL function or a script that uses

  Gregory Stark

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to