Postgres Pro
Downloads
Home   >   mailing lists

Re: How to speed WAL apply in destination - Mailing list pgsql-admin

From Raghvendra Choudhary
Subject Re: How to speed WAL apply in destination
Date
Msg-id CAC-xdJp9qn0uQoKB0YywjeRrF_cJjkxw754G2_3g=zJh=ndu-Q@mail.gmail.com
Whole thread Raw
In response to Re: How to speed WAL apply in destination  (Bryon Roché <kain@kain.org>)
Responses Re: How to speed WAL apply in destination  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-admin
Tree view
Hello Bryon,

Can you please help me out to install the postgresql cluster steps


Raghvendra Choudhary
 DevOps Engineer | www.digivalet.com

Logo

T:  +91.731.6667891

M: +91.96307.90947

E:  raghvendra.choudhary@digivalet.com

Banner


On Mon, Dec 12, 2022 at 5:08 PM Bryon Roché <kain@kain.org> wrote:


On December 9, 2022 10:50:07 AM UTC, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>On Fri, 2022-12-09 at 08:47 +0000, Bryon Roché 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.
>
>That is spectacularly bad advice.

It is situational advice, and depending on your application, not bad advice at all. It is certainly not something you want off by default, or even regularly.

In fact, the PostgreSQL 15 (and earlier) versions cover this in the documentation for the fsync and synchronous_commit parameters in section 20.5, including considerations involved in deciding when to use those arameters, along with further references in the documentation to cover more of the performance, synchronicity, and durability parameters, in detail.


pgsql-admin by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: How to speed WAL apply in destination
Next
From: Nikhil Shetty
Date:
Subject: pg_ls_waldir does not work on standy