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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Is there any impact if "#wal_keep_segments = 0 " and "checkpoint_segments = 128" postgresql.conf file.
Date: 2018-10-15 07:46:47
Message-ID: 2e2ea4412f3067e69be85758f6f624be33fd1362.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rijo Roy 2018-10-15 08:01:20 Enabling autovacuum per table
Previous Message Raghavendra Rao J S V 2018-10-15 07:10:45 Is there any impact if "#wal_keep_segments = 0 " and "checkpoint_segments = 128" postgresql.conf file.