Re: Avoid MVCC using exclusive lock possible? - Mailing list pgsql-hackers

From Jon Jensen
Subject Re: Avoid MVCC using exclusive lock possible?
Date
Msg-id Pine.LNX.4.58.0402282119440.13411@louche.swelter.net
Whole thread Raw
In response to Avoid MVCC using exclusive lock possible?  ("Stephen" <private@xxxxxxx.com>)
Responses Re: Avoid MVCC using exclusive lock possible?  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
On Tue, 24 Feb 2004, Stephen wrote:

> It came to my mind that what if there could be a mechanism in place to allow
> overwriting portions of the same row *whenever possible* instead of creating
> a new row as MVCC would require.

How would you do a rollback if an error occurred mid-query? How would you
keep your table from being a big pile of junk if a power failure happened
during the query?

Jon


pgsql-hackers by date:

Previous
From: abe@purdue.edu (Vic Abell)
Date:
Subject: Re: Too-many-files errors on OS X
Next
From: Bruce Momjian
Date:
Subject: Re: 7.3.6 for Monday ... still a go?