From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: kain@kain.org, Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: How to speed WAL apply in destination
Date: Fri, 9 Dec 2022 10:07:25 +0000 (UTC)
Message-ID: <68322219.2585895.1670580445682@mail.yahoo.com> (raw)
In-Reply-To: <1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org>
References: <364439211.2445507.1670562179127.ref@mail.yahoo.com>
<364439211.2445507.1670562179127@mail.yahoo.com>
<1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org>
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@kain.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@yahoo.com> wrote:
Hi All
How to speed up WAL apply process in secondary? Any parameter available from postgres, apart from disk speed?
RegardsSasi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sashikumard@yahoo.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to speed WAL apply in destination
In-Reply-To: <68322219.2585895.1670580445682@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox