Re: Recovery will take 10 hours

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@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954