Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file. - Mailing list pgsql-general

From Jehan-Guillaume (ioguix) de Rorthais
Subject Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.
Date
Msg-id 20181015111308.7821dbf5@firost
Whole thread Raw
In response to Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
Tree view 
On Mon, 15 Oct 2018 09:46:47 +0200
Laurenz Albe <laurenz.albe@cybertec.at> wrote:

> Raghavendra Rao J S V wrote:
> > Is there any impact if  "#wal_keep_segments = 0 " and "checkpoint_segments
> > = 128" postgresql.conf file. If yes,what is the imapct?  
> 
> Yes.
> - You will have fewer checkpoints requested by data modification activity.
> - Crash recovery might take longer.

And considering wal_keep_segments, there is no impact on perf/recovery. This
mostly related to the standby replication lag allowed and some other solutions
exists (slots, archiving).

pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Re: Regarding varchar max length in postgres
Next
From: Raghavendra Rao J S V
Date:
Subject: Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.