Re: Slow PITR restore - Mailing list pgsql-general

From Tom Lane
Subject Re: Slow PITR restore
Date
Msg-id 4109.1197528092@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow PITR restore  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Slow PITR restore
List pgsql-general
"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?

            regards, tom lane

pgsql-general by date:

Previous
From: Gerald Timothy Quimpo
Date:
Subject: Re: what is the date format in binary query results
Next
From: "Magnus Hagander"
Date:
Subject: Re: timestamp with time zone