Re: Slow PITR restore

On Dec 12, 2007, at 11:29 AM, Joshua D. Drake wrote:

> 8 seconds for a single archive recovery is very slow in
> consideration of this machine. Even single threaded that seems slow.
>

I've seen this on my PITR restores (thankfully, they were for
fetching some old data, not because we expoded).  On a 2.4ghz opteron
it took 5-50 seconds per wal segment, and there were a LOT of
segments (replay took hours and hours).  I asked a few folks and was
told it is the nature of the beast.  Hopefully something in 8.4 can
be done.

--
Jeff Trout <jeff@jefftrout.com>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/