| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| 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 06:41:32 |
| Message-ID: | 4109.1197528092@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
"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?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-12-13 06:45:18 | Re: timestamp with time zone |
| Previous Message | Ken Johanson | 2007-12-13 06:37:50 | Re: RETURNING clause: how to specifiy column indexes? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-12-13 06:50:45 | Re: [HACKERS] "distributed checkpoint" |
| Previous Message | Tom Lane | 2007-12-13 06:36:33 | Re: little correction |