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 <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
