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

current
Discussion topic

Back to topic list

Lots of Idle Transactions

Reply

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.

Thanks,

Trevor

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

Messages

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: