Re: How to speed WAL apply in destination

Hello Bryon,

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

*Raghvendra Choudhary*
DevOps Engineer | www.digivalet.com <https://digivalet.com>

[image: Logo]

T: +91.731.6667891

M: +91.96307.90947

E: raghvendra(dot)choudhary(at)digivalet(dot)com <raghvendra(dot)choudhary(at)digivalet(dot)com>

[image: Banner]

On Mon, Dec 12, 2022 at 5:08 PM Bryon Roché <kain(at)kain(dot)org> wrote:

>
>
> On December 9, 2022 10:50:07 AM UTC, Laurenz Albe <
> laurenz(dot)albe(at)cybertec(dot)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.
>
>
>