Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time

Поиск
Список
Период
Сортировка
От Ivan N. Ivanov
Тема Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time
Дата
Msg-id CAC+=vAwmjbd19TfELScKA1bBHxCUvR3xdr3aDDzLcy6yN7=fVg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Setting up streaming replication on large database (20+ TB) for the first time  (Christophe Pettus <xof@thebuild.com>)
Ответы Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time  ("Ivan N. Ivanov" <ivan.ni@telebid-pro.com>)
Список pgsql-general
Дерево обсуждения
Thank you for your answer! I have found this tool and I will try it tomorrow to see if this "read-ahead" feature will speed up the process.

On Wed, Aug 17, 2022 at 11:09 PM Christophe Pettus <xof@thebuild.com> wrote:


> On Aug 17, 2022, at 13:06, Ivan N. Ivanov <ivan.ni@telebid-pro.com> wrote:
>
> How to speed up recovering of WAL files?

Since you are running on your own hardware, you might take a look at:

        https://github.com/TritonDataCenter/pg_prefaulter

В списке pgsql-general по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Setting up streaming replication on large database (20+ TB) for the first time
Следующее
От: gzh
Дата:
Сообщение: Different execution plan between PostgreSQL 8.2 and 12.5