From: | Alban Hertroys <alban(at)magproductions(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Transaction size |
Date: | 2005-01-07 17:06:34 |
Message-ID: | 41DEC19A.7060705@magproductions.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is it possible that there is some limitation to the number of statements
in a single transaction? I'm trying to debug a problem where a program
locks up during an insert[*].
Actually, there are 3 simultaneous transactions going on, all doing
inserts of about 3000 records each. The problem occurs when I'm about
400 records from the end of the transaction.
As they're inserts, and therefore not even touching the same data, I'm
quite certain it's not some kind of row locking issue (does that even
happen at all with MVCC?).
I'm just fishing around, it may just as well turn out to be a threading
problem in my program, but I've been staring at it for days now and it
doesn't seem to make more sense then it did at the begin...
Any insights much appreciated.
[*]: It prints debug output before the query is executed, and it should
after.
BTW: My thanks to whoever changed the color of the links in the docs to
the current color. The contrast/readability is much better now (compared
to last week).
From | Date | Subject | |
---|---|---|---|
Next Message | Culley Harrelson | 2005-01-07 17:09:49 | Re: does "select count(*) from mytable" always do a seq scan? |
Previous Message | Alex Turner | 2005-01-07 17:04:11 | Re: need help Connect failure in an applet |