Horton

Re: 7.4?

Ed L. <pgsql@bluepolka.net>

View thread View on postgr.es
From: "Ed L." <pgsql@bluepolka.net>
To: Andrew Sullivan <andrew@libertyrms.info>, PostgreSQL General <pgsql-general@postgresql.org>
Date: 2003-02-28T01:04:51Z
Lists: 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