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

Поиск
Список
Период
Сортировка
От Nicolas Grilly
Тема Re: Is there a way to speed up WAL replay?
Дата
Msg-id CAG3yVS6G-_8s2Qj3kGzOpc+iSS3Z7nqfKr_TawMgnRBbY-NjiA@mail.gmail.com
обсуждение исходный текст
Ответ на Is there a way to speed up WAL replay?  (Torsten Förtsch <tfoertsch123@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Is there a way to speed up WAL replay?
Следующее
От: Rich Shepard
Дата:
Сообщение: Broken postgres links need to find callers