From: Bryon Roché <kain@kain.org>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: How to speed WAL apply in destination
Date: Fri, 09 Dec 2022 08:47:55 +0000
Message-ID: <1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org> (raw)
In-Reply-To: <364439211.2445507.1670562179127@mail.yahoo.com>
References: <364439211.2445507.1670562179127.ref@mail.yahoo.com>
<364439211.2445507.1670562179127@mail.yahoo.com>
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: kain@kain.org, pgsql-admin@lists.postgresql.org
Subject: Re: How to speed WAL apply in destination
In-Reply-To: <1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org>
* 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