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 SAVEPOINT a lot? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
