> 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).
From:
"Jehan-Guillaume (ioguix) de Rorthais" Date: Subject:
Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.