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: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow PITR restore
Date: 2007-12-12 03:24:58
Message-ID: 475F548A.80805@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:
>> ... Now I understand that restoring log files can be slow but this is a big
>> machine.
>
> Yeah, restoring is known to be less than speedy, because essentially
> zero optimization work has been done on it.
>
> Heikki has improved matters a bit in 8.3, but I suspect it's still
> not great.

Wow, o.k. well it is something we (the community) really should look at
for 8.4. I am surprised that it is slower than just walking through the
xlogs on recovery. I am sure there is a reason just surprised.

Thanks for answering.

Sincerely,

Joshua D. Drake

>
> regards, tom lane
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magicloud Wang 2007-12-12 03:43:44 Would it be OK if I put db file on a ext2 filesystem?
Previous Message Tom Lane 2007-12-12 03:21:16 Re: Slow PITR restore

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-12-12 03:32:07 Re: [hensa22@yahoo.es: Re: [pgsql-es-ayuda] SLL error 100% cpu]
Previous Message Tom Lane 2007-12-12 03:21:16 Re: Slow PITR restore