| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Renato Oliveira <renato(dot)oliveira(at)grant(dot)co(dot)uk> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: PITR load on servers - increased 20% |
| Date: | 2010-03-18 09:07:57 |
| Message-ID: | 1268903277.3827.1699.camel@ebony |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Campbell, Lance | 2010-03-18 14:45:06 | pg_dump from one server to another using SSL |
| Previous Message | Simon Riggs | 2010-03-18 09:02:22 | Re: Autovac vs manual with analyze |