Re: Slow PITR restore

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
>

In response to

Responses

Browse pgsql-general by date

  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()?

Browse pgsql-hackers by date

  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"