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 <tfoertsch...@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 >
