Thanks a lot. On Mon, 15 Oct 2018 at 14:43, Jehan-Guillaume (ioguix) de Rorthais < iog...@free.fr> wrote:
> On Mon, 15 Oct 2018 09:46:47 +0200 > Laurenz Albe <laurenz.a...@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). > -- Regards, Raghavendra Rao J S V Mobile- 8861161425
