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

Re: PITR performance costs

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: postgresql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PITR performance costs
Date: 2007-05-28 16:31:33
Message-ID: 465B03E5.1000109@enterprisedb.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-performance by date

Next:From: Dave CramerDate: 2007-05-28 18:48:55
Subject: Re: PITR performance costs
Previous:From: A. KretschmerDate: 2007-05-28 12:54:28
Subject: Re: PITR performance costs

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