Postgres Pro
Downloads
Home   >   mailing lists

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

From Nicolas Grilly
Subject Re: Is there a way to speed up WAL replay?
Date
Msg-id CAG3yVS6G-_8s2Qj3kGzOpc+iSS3Z7nqfKr_TawMgnRBbY-NjiA@mail.gmail.com
Whole thread Raw
In response to Is there a way to speed up WAL replay?  (Torsten Förtsch <tfoertsch123@gmail.com>)
List pgsql-general
Tree view
This tool may be useful:

Faults pages into PostgreSQL shared_buffers or filesystem caches in advance of WAL apply

Nicolas

On Wed, Oct 31, 2018 at 6:38 AM Torsten Förtsch <tfoertsch123@gmail.com> wrote:
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: Stephen Frost
Date:
Subject: Re: Is there a way to speed up WAL replay?
Next
From: Rich Shepard
Date:
Subject: Broken postgres links need to find callers