| From: | Nicolas Grilly <nicolas(at)gardentechno(dot)com> |
|---|---|
| To: | tfoertsch123(at)gmail(dot)com |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Is there a way to speed up WAL replay? |
| Date: | 2018-10-31 15:35:49 |
| Message-ID: | CAG3yVS6G-_8s2Qj3kGzOpc+iSS3Z7nqfKr_TawMgnRBbY-NjiA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2018-10-31 17:18:50 | Broken postgres links need to find callers |
| Previous Message | Stephen Frost | 2018-10-31 15:32:53 | Re: Is there a way to speed up WAL replay? |