From: Laurenz Albe <laurenz.albe@cybertec.at>
To: 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 11:50:07 +0100
Message-ID: <44581ceb3c9c96f48e131ed3de33389db07317e9.camel@cybertec.at> (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>
On Fri, 2022-12-09 at 08:47 +0000, Bryon Roché wrote:
> On December 9, 2022 5:02:59 AM UTC, SASIKUMAR Devaraj <sashikumard@yahoo.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
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: laurenz.albe@cybertec.at, kain@kain.org, pgsql-admin@lists.postgresql.org
Subject: Re: How to speed WAL apply in destination
In-Reply-To: <44581ceb3c9c96f48e131ed3de33389db07317e9.camel@cybertec.at>
* 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