Re: Recovery will take 10 hours

[Jeff Frost <jeff(at)frostconsultingllc(dot)com>]

On Thu, 20 Apr 2006, Brendan Duddridge wrote:

> Hi,
>
> We had a database issue today that caused us to have to restore to our most 
> recent backup. We are using PITR so we have 3120 WAL files that need to be 
> applied to the database.
>
> After 45 minutes, it has restored only 230 WAL files. At this rate, it's 
> going to take about 10 hours to restore our database.
>
> Most of the time, the server is not using very much CPU time or I/O time. So 
> I'm wondering what can be done to speed up the process?

Brendan,

Where are the WAL files being stored and how are they being read back?

--
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954