Login | Register
My pages Projects Community openCollabNet

Discussions > users > Lots of Idle Transactions

Project highlights: Stable Version: 1.6.1, Development Version: 1.7.6

Discussion topic

2020-03-13: This site is going to be decommissioned and shut down very soon. Please copy and archive any data you wish to keep ASAP

Back to topic list

Lots of Idle Transactions


Author Trevor Astrope <astrope at tabbweb dot com>
Full name Trevor Astrope <astrope at tabbweb dot com>
Date 2005-11-14 11:02:25 PST
Message We've noticed that there are always many connections from the current server to
our postgresql db. The problem is that the connections are all in an open
transaction. This prevents us from vacuuming other structures in the db.

Is it possible for current to do a commit after each transaction or use
autocommit to prevent the long running transactions?

We're using current 1.6.0 and postgresql 8.0.3.



« Previous message in topic | 1 of 2 | Next message in topic »


Show all messages in topic

Lots of Idle Transactions Trevor Astrope <astrope at tabbweb dot com> Trevor Astrope <astrope at tabbweb dot com> 2005-11-14 11:02:25 PST
     Re: Lots of Idle Transactions theslack Jack Neely 2005-11-14 17:57:47 PST
Messages per page: