From: Stephen Frost <sfrost@snowman.net>
To: Dave Cramer <pg@fastcrypt.com>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Re: PITR performance costs
Date: Mon, 28 May 2007 15:46:03 -0400
Message-ID: <20070528194603.GO7531@tamriel.snowman.net> (raw)
In-Reply-To: <AB783D40-6095-40EB-A779-B3387EF87136@fastcrypt.com>
References: <81165B3E-1099-4388-88F1-FA27A3AD92BC@fastcrypt.com>
<465B03E5.1000109@enterprisedb.com>
<AB783D40-6095-40EB-A779-B3387EF87136@fastcrypt.com>
Dave, et al,
* Dave Cramer (pg@fastcrypt.com) wrote:
> Don't the archived logs have to be copied as well as the regular WAL
> logs get recycled ?
Yes, but I'd expect at the point they're being copied off to some other
store (probably a seperate disk, or even over the network to another
system, etc), they're probably in the system cache, so you're probably
not going out to disk to get those blocks anyway. That might not be the
case on a slow-write system, but in those cases it seems at least
somewhat unlikely you'll be hit very hard by the occational 16MB copy
off the disk...
Thanks,
Stephen
> On 28-May-07, at 12:31 PM, Heikki Linnakangas wrote:
>
> >Dave Cramer wrote:
> >>Since PITR has to enable archiving does this not increase the
> >>amount of disk I/O required ?
> >
> >There's no difference in normal DML operations, but some bulk
> >operations like CREATE INDEX that don't otherwise generate WAL,
> >need to be WAL logged when archiving is enabled.
> >
> >--
> > Heikki Linnakangas
> > EnterpriseDB http://www.enterprisedb.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqAttachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sfrost@snowman.net, pg@fastcrypt.com, heikki@enterprisedb.com
Subject: Re: PITR performance costs
In-Reply-To: <20070528194603.GO7531@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox