Is there a way to speed up WAL replay?

Поиск
Список
Период
Сортировка
От Torsten Förtsch
Тема Is there a way to speed up WAL replay?
Дата
Msg-id CAKkG4_nRs+wiDpBrhAU=76XHMBFi08Hb47HD_Fvn0q-+U-h5-A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Is there a way to speed up WAL replay?  (Jeff Janes <jeff.janes@gmail.com>)
Re: Is there a way to speed up WAL replay?  (Stephen Frost <sfrost@snowman.net>)
Re: Is there a way to speed up WAL replay?  (Nicolas Grilly <nicolas@gardentechno.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Igor Korot
Дата:
Сообщение: Re: Fwd: Log file
Следующее
От: Tony Shelver
Дата:
Сообщение: Re: Function for Exception Logging