Is there a way to speed up WAL replay?

From: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Is there a way to speed up WAL replay?
Date: 2018-10-31 05:38:13
Message-ID: CAKkG4_nRs+wiDpBrhAU=76XHMBFi08Hb47HD_Fvn0q-+U-h5-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Shelver 2018-10-31 06:45:15 Re: Function for Exception Logging
Previous Message Igor Korot 2018-10-31 04:32:33 Re: Fwd: Log file