Re: Slow PITR restore - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Slow PITR restore
Date
Msg-id 47600C56.4020205@commandprompt.com
Whole thread Raw
In response to Re: Slow PITR restore  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Slow PITR restore
List pgsql-general
Simon Riggs wrote:
> On Wed, 2007-12-12 at 07:36 -0800, Joshua D. Drake wrote:
>
>> We can't really expect people to use PITR if they new
>> it would take hours to recover even on the size of machine I was working on.
>
> That's not true statement in all cases and can often be improved with
> some monitoring and tuning. Just get your client to call me :-)
>

Uhh.. right.

> Are you doing replication, or a PITR for another reason?

Warm standby. Normally we pull every 5 minutes which is why we hadn't
noticed this before. However last night we pulled a full sync and
recover and that is when we noticed it.

8 seconds for a single archive recovery is very slow in consideration of
this machine. Even single threaded that seems slow.

Sincerely,

Joshua D. Drake



pgsql-general by date:

Previous
From: "Douglas McNaught"
Date:
Subject: Re: Would it be OK if I put db file on a ext2 filesystem?
Next
From: "David"
Date:
Subject: General Q's