Postgres Pro
Downloads
Home   >   mailing lists

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

From Raghavendra Rao J S V
Subject Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.
Date
Msg-id CAEHH7R50c1vKuK7ywjADv_QiNGDZ0zx_h2L0xOJRiWFe1pDQJQ@mail.gmail.com
Whole thread Raw
Responses Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.
List pgsql-general
Tree view
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

pgsql-general by date:

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