Re: Performance of archive logging in a PITR restore

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Mark Steben <msteben(at)autorevenue(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance of archive logging in a PITR restore
Date: 2009-03-16 16:21:30
Message-ID: 1237220490.29552.1.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-03-16 16:26:27 Re: Proposal of tunable fix for scalability of 8.4
Previous Message Mark Steben 2009-03-16 16:11:23 Performance of archive logging in a PITR restore