Subject: Re: PITR load on servers - increased 20%
From: Simon Riggs <simon@2ndQuadrant.com>
To: Renato Oliveira <renato.oliveira@grant.co.uk>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <7965A9DCF12CC14984420BCC37B1608F25AAFB989B@Elzar.grant.co.uk>
References: <4B9A6E8B.4050303@magneta.com.cy>
	<1268556612.3825.5025.camel@ebony>  <4B9DFD67.3050106@magneta.com.cy>
	<1268647021.3825.7469.camel@ebony>
	<7965A9DCF12CC14984420BCC37B1608F25AAFB989B@Elzar.grant.co.uk>
Content-Type: text/plain
Date: Thu, 18 Mar 2010 09:07:57 +0000
Message-Id: <1268903277.3827.1699.camel@ebony>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Tue, 2010-03-16 at 10:05 +0000, Renato Oliveira wrote:

> I have been testing PITR and I have noticed a 20% increase on the load of the Disk subsystem.
> 
> Is that a normal thing to expect? Have you come across this or have you noticed this increase?
> 
> I know some of you guys have been using it for quite some time, would you mind in sharing your experiences, please?

I think you need to explain what things you've been testing and how.

There are some well documented bulk data load optimizations that we
cannot take advantage of when running archiving, but apart from those
the load is actually very low in normal running.

-- 
 Simon Riggs           www.2ndQuadrant.com