pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: kain@kain.org, Laurenz Albe <laurenz.albe@cybertec.at>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: How to speed WAL apply in destination
Date: Tue, 20 Dec 2022 11:32:34 +0000 (UTC)
Message-ID: <573865124.1608666.1671535954355@mail.yahoo.com> (raw)
In-Reply-To: <FDCF3710-A2AA-4D39-ACEE-27B979A51878@kain.org>
References: <364439211.2445507.1670562179127.ref@mail.yahoo.com>
	<364439211.2445507.1670562179127@mail.yahoo.com>
	<1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org>
	<44581ceb3c9c96f48e131ed3de33389db07317e9.camel@cybertec.at>
	<FDCF3710-A2AA-4D39-ACEE-27B979A51878@kain.org>

Hi all
Issue resolved after increasing memory. 

Sent from Yahoo Mail on Android 
 
  On Mon, Dec 12, 2022 at 5:09 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.


  

view thread (15+ messages)

Message-ID: <573865124.1608666.1671535954355@mail.yahoo.com>
Permalink:  ../573865124.1608666.1671535954355@mail.yahoo.com/
Also on:    postgresql.org/message-id/573865124.1608666.1671535954355@mail.yahoo.com

 · 

reply
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, laurenz.albe@cybertec.at, pgsql-admin@lists.postgresql.org
  Subject: Re: How to speed WAL apply in destination
  In-Reply-To: <573865124.1608666.1671535954355@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