Transaction size

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).

Responses

Browse pgsql-general by date

  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