Re: transaction timeout - Mailing list pgsql-general

From Dr NoName
Subject Re: transaction timeout
Date
Msg-id 20050726160833.79485.qmail@web31502.mail.mud.yahoo.com
Whole thread Raw
In response to Re: transaction timeout  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
> On Tue, Jul 26, 2005 at 08:33:19AM -0700, Dr NoName
> wrote:
>
> > A single client should not be able to bring the
> entire
> > database down. The DB should recognize that the
> client
> > went down and roll back the transaction. That
> would be
> > the ideal solution. Anything else we can do to
> remedy
> > the situation?
>
> Now wait just a second.  The database is not down at
> all just because
> somebody left a transaction open.  The real problem
> is that that open
> transaction is having some resources locked, right?

right, but that's effectively the same thing: users
cannot write to the database and in some cases can't
even read from it.

> I guess the real answer is not to leave transactions
> open.  If you do
> that by design, say because the app shows a data
> modification window,
> and keeps a transaction open just to be able to save
> the changes later,
> then you really need to rethink your app design.

There is no user interaction in the middle of a
transaction. But there are other things we have to do
(file system I/O, heavy processing, etc.) Those
operations really do need to be interleaved with the
DB writes.

thanks,

Eugene

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-general by date:

Previous
From: "Walsh, Richard (Richard)"
Date:
Subject: dropping non-existent tables
Next
From: Dr NoName
Date:
Subject: Re: transaction timeout