Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance of archive logging in a PITR restore - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Performance of archive logging in a PITR restore
Date
Msg-id 1237220490.29552.1.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Performance of archive logging in a PITR restore  ("Mark Steben" <msteben@autorevenue.com>)
Responses Re: Performance of archive logging in a PITR restore  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-performance
Tree view 
On Mon, 2009-03-16 at 12:11 -0400, Mark Steben wrote:
> First of all, I did pose this question first on the pgsql – admin
> mailing list.


> The issue is that during a restore on a remote site, (Postgres 8.2.5)
>
> archived logs are taking an average of 35 – 40 seconds apiece to
> restore.

Archive logs are restored in a serialized manner so they will be slower
to restore in general.

Joshua D. Drake



--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997

pgsql-performance by date:

Previous
From: "Mark Steben"
Date:
Subject: Performance of archive logging in a PITR restore
Next
From: Matthew Wakeling
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4