Postgres Pro
Downloads
Home   >   mailing lists

Is there a way to speed up WAL replay? - Mailing list pgsql-general

From Torsten Förtsch
Subject Is there a way to speed up WAL replay?
Date
Msg-id CAKkG4_nRs+wiDpBrhAU=76XHMBFi08Hb47HD_Fvn0q-+U-h5-A@mail.gmail.com
Whole thread Raw
Responses Re: Is there a way to speed up WAL replay?  (Jeff Janes <jeff.janes@gmail.com>)
Re: Is there a way to speed up WAL replay?  (Stephen Frost <sfrost@snowman.net>)
Re: Is there a way to speed up WAL replay?  (Nicolas Grilly <nicolas@gardentechno.com>)
List pgsql-general
Tree view
Hi,

I am working on restoring a database from a base backup + WAL. With the default settings the database replays about 3-4 WAL files per second. The startup process takes about 65% of a CPU and writes data with something between 50 and 100 MB/sec.

Is there a way to speed that up? The disk can easily sustain 400-500 MB/sec.

Thanks,
Torsten

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Fwd: Log file
Next
From: Tony Shelver
Date:
Subject: Re: Function for Exception Logging