Re: A long-running transaction - Mailing list pgsql-sql

From Joe
Subject Re: A long-running transaction
Date
Msg-id 1176482556.782.83.camel@pampa
Whole thread Raw
In response to Re: A long-running transaction  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: A long-running transaction  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
Hi Andrew,

On Fri, 2007-04-13 at 07:49 -0400, Andrew Sullivan wrote:
> Because in the general case, you need the intermediate rows.  The
> problem is that you'd have to write a special piece of code to catch
> the case where nobody else can see the row that you're about to
> expire, and that test isn't free.  Therefore, you do it the same way
> any other row gets expired.

Just curious:  is there a way to defeat MVCC?  i.e., if you can lock the
database exclusively, there won't be any readers or writers?

Joe



pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: A long-running transaction
Next
From: Andrew Sullivan
Date:
Subject: Re: A long-running transaction