Re: PITR performance costs - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: PITR performance costs
Date
Msg-id b42b73150705290606t29535f8bi9930d73215664964@mail.gmail.com
Whole thread Raw
In response to PITR performance costs  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-performance
On 5/28/07, Dave Cramer <pg@fastcrypt.com> wrote:
> Since PITR has to enable archiving does this not increase the amount
> of disk I/O required ?

I've set up warm standbys on a few servers (some of them quite
busy!)...the additional load is virtually unmeasurable.  I usually
don't copy the files locally...I scp them off to some other server.
When archived, the WAL files are likely cached but there is some
overhead to copying them off however.

merlin

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: Feature suggestion : FAST CLUSTER
Next
From: "Merlin Moncure"
Date:
Subject: Re: general PG network slowness (possible cure) (repost)