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: (view raw or whole 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

In response to


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-2015 The PostgreSQL Global Development Group