From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Jeff Trout <threshar(at)threshar(dot)is-a-geek(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Slow PITR restore |
Date: | 2007-12-13 07:08:35 |
Message-ID: | 4760DA73.4010905@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Johanson | 2007-12-13 07:17:37 | Re: RETURNING clause: how to specifiy column indexes? |
Previous Message | Kris Jurka | 2007-12-13 07:05:57 | Re: Synthesize support for Statement.getGeneratedKeys()? |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-12-13 08:27:25 | Re: Slow PITR restore |
Previous Message | Magnus Hagander | 2007-12-13 06:50:45 | Re: [HACKERS] "distributed checkpoint" |