From: Simon Riggs <simon@2ndQuadrant.com>
To: Renato Oliveira <renato.oliveira@grant.co.uk>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: PITR load on servers - increased 20%
Date: Thu, 18 Mar 2010 09:07:57 +0000
Message-ID: <1268903277.3827.1699.camel@ebony> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndQuadrant.com, renato.oliveira@grant.co.uk
Subject: Re: PITR load on servers - increased 20%
In-Reply-To: <1268903277.3827.1699.camel@ebony>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox