Re: 7.4?

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 7.4?
Date: 2003-02-28 01:04:51
Message-ID: 200302271804.51935.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

  • Re: 7.4? at 2003-02-27 22:28:49 from Andrew Sullivan

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-02-28 01:17:24 Re: use of %TYPE
Previous Message Ed L. 2003-02-28 00:51:05 Re: 7.4?