Re: Is there a way to speed up WAL replay?

[Nicolas Grilly <nicolas@xxxxxxxxxxxxxxxx>]

This tool may be useful:

https://github.com/joyent/pg_prefaulter

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@xxxxxxxxx> 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