Re: 7.4? - Mailing list pgsql-general

From Ed L.
Subject Re: 7.4?
Date
Msg-id 200302271804.51935.pgsql@bluepolka.net
Whole thread Raw
In response to Re: 7.4?  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
On Thursday February 27 2003 3:28, Andrew Sullivan wrote:
> On Thu, Feb 27, 2003 at 02:21:23PM -0700, Ed L. wrote:
> > Unfortunately, dbmirror does go through all the iterations, even
> > if
>
> So does dbmirror keep a copy of the row somewhere?  Doesn't that
> add a lot to i/o?

Yes and yes, it would seem so.  It could be a significant performance
issue for a database with lots of updates in a short amount of time.
The "current-as-of-snapshot" approach would be a valuable
enhancement.

Ed


pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: 7.4?
Next
From: Stephan Szabo
Date:
Subject: Re: use of %TYPE