Is there any impact if "#wal_keep_segments = 0 " and "checkpoint_segments = 128" postgresql.conf file.

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Is there any impact if "#wal_keep_segments = 0 " and "checkpoint_segments = 128" postgresql.conf file.
Date: 2018-10-15 07:10:45
Message-ID: CAEHH7R50c1vKuK7ywjADv_QiNGDZ0zx_h2L0xOJRiWFe1pDQJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Is there any impact if "#wal_keep_segments = 0 " and "checkpoint_segments
= 128" postgresql.conf file. If yes,what is the imapct?

*checkpoint_segments = 128* # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 5min # range 30s-1h
#checkpoint_completion_target = 0.5 # checkpoint target duration, 0.0 - 1.0
#checkpoint_warning = 30s # 0 disables
*#wal_keep_segments = 0* # in logfile segments, 16MB each; 0 disables
wal_level = archive # minimal, archive, or hot_standby
*archive_mode = off* # allows archiving to be done

--
Regards,
Raghavendra Rao J S V

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2018-10-15 07:46:47 Re: Is there any impact if "#wal_keep_segments = 0 " and "checkpoint_segments = 128" postgresql.conf file.
Previous Message Raghavendra Rao J S V 2018-10-15 07:07:22 Re: Max number of WAL files in pg_xlog directory for Postgres 9.2 version