Skip site navigation (1) Skip section navigation (2)

Re: PITR performance costs

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: postgresql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PITR performance costs
Date: 2007-05-28 18:48:55
Message-ID: AB783D40-6095-40EB-A779-B3387EF87136@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-performance
Heikki,

Don't the archived logs have to be copied as well as the regular WAL  
logs get recycled ?

Dave
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


In response to

Responses

pgsql-performance by date

Next:From: Stephen FrostDate: 2007-05-28 19:46:03
Subject: Re: PITR performance costs
Previous:From: Heikki LinnakangasDate: 2007-05-28 16:31:33
Subject: Re: PITR performance costs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group