Re: How to speed WAL apply in destination

From: SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>
To: 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:07:25
Message-ID: 68322219.2585895.1670580445682@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks Bryon. Will deep dive into this. Any other parameters or parallel writes will help? 

Sent from Yahoo Mail on Android

On Fri, 9 Dec 2022 at 3:12 PM, Bryon Roché<kain(at)kain(dot)org> wrote: There are fsync parameters which can be set to off that may provide a modest speed increase, at the cost of removing crash safety.

On December 9, 2022 5:02:59 AM UTC, SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com> wrote:
Hi All
How to speed up WAL apply process in secondary? Any parameter available from postgres, apart from disk speed? 
RegardsSasi

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2022-12-09 10:50:07 Re: How to speed WAL apply in destination
Previous Message Bryon Roché 2022-12-09 08:47:55 Re: How to speed WAL apply in destination