Re: PITR performance costs - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: PITR performance costs
Date
Msg-id 465B03E5.1000109@enterprisedb.com
Whole thread Raw
In response to PITR performance costs  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: PITR performance costs
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: PITR performance costs
Next
From: Dave Cramer
Date:
Subject: Re: PITR performance costs