| From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
|---|---|
| To: | Brendan Duddridge <brendan(at)clickspace(dot)com> |
| Cc: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Recovery will take 10 hours |
| Date: | 2006-04-20 21:19:43 |
| Message-ID: | Pine.LNX.4.64.0604201419130.1527@glacier.frostconsultingllc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guido Neitzer | 2006-04-20 21:19:44 | Re: Performance decrease |
| Previous Message | Brendan Duddridge | 2006-04-20 21:13:31 | Re: Recovery will take 10 hours |