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

From: "Ivan N(dot) Ivanov" <ivan(dot)ni(at)telebid-pro(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time
Date: 2022-08-17 20:13:19
Message-ID: CAC+=vAwmjbd19TfELScKA1bBHxCUvR3xdr3aDDzLcy6yN7=fVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)thebuild(dot)com> wrote:

>
>
> > On Aug 17, 2022, at 13:06, Ivan N. Ivanov <ivan(dot)ni(at)telebid-pro(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message gzh 2022-08-18 03:01:04 Different execution plan between PostgreSQL 8.2 and 12.5
Previous Message Christophe Pettus 2022-08-17 20:09:01 Re: Setting up streaming replication on large database (20+ TB) for the first time