Re: How to speed WAL apply in destination

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Bryon Roché <kain(at)kain(dot)org>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to speed WAL apply in destination
Date: 2022-12-09 10:50:07
Message-ID: 44581ceb3c9c96f48e131ed3de33389db07317e9.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2022-12-09 at 08:47 +0000, Bryon Roché wrote:
> On December 9, 2022 5:02:59 AM UTC, SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com> wrote:
> > How to speed up WAL apply process in secondary? Any parameter available from postgres, apart from disk speed? 
>
> There are fsync parameters which can be set to off that may provide a modest speed increase, at the cost of removing crash safety.

That is spectacularly bad advice.

Is the disk the bottleneck at all?

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message SASIKUMAR Devaraj 2022-12-09 10:57:03 Re: How to speed WAL apply in destination
Previous Message SASIKUMAR Devaraj 2022-12-09 10:07:25 Re: How to speed WAL apply in destination