Re: Slow PITR restore - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Slow PITR restore
Date
Msg-id 4760DA73.4010905@commandprompt.com
Whole thread Raw
In response to Re: Slow PITR restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Slow PITR restore
List pgsql-general
Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
>> Tom Lane wrote:
>>> You sure about that?  I tested CVS HEAD just now, by setting the
>>> checkpoint_ parameters really high,
>
>> ... And:
>
>>> 2007-12-13 00:55:20 EST     LOG:  restored log file "00000001000007E10000006B" from archive
>
> Hmm --- I was testing a straight crash-recovery scenario, not restoring
> from archive.  Are you sure your restore_command script isn't
> responsible for a lot of the delay?

Now that's an interesting thought, I will review in the morning when I
have some more IQ points back.

Joshua D. Drake

>
>             regards, tom lane
>


pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: RETURNING clause: how to specifiy column indexes?
Next
From: Ken Johanson
Date:
Subject: Re: RETURNING clause: how to specifiy column indexes?