difference between checkpoint_segments and wal_keep_segments in postgres configuration file

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: difference between checkpoint_segments and wal_keep_segments in postgres configuration file
Date: 2018-04-10 17:36:54
Message-ID: CAEHH7R7dSEka9StaNaHPV=72NLHfBkBreC2pqihWzCi-LRysng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am not clear the difference between checkpoint_segments and
wal_keep_segments .

I would like to now below things. Please explain.Thanks in advance.

- Difference between *checkpoint_segments *and *wal_keep_segments *
value
- Role of *checkpoint_segments *and *wal_keep_segments *
- Which one should has higher value.

--
Regards,
Raghavendra Rao J S V

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra Rao J S V 2018-04-10 17:45:22 Planning to change autovacuum_vacuum_scale_factor value to zero. Please suggest me if any negative impact.
Previous Message Raghavendra Rao J S V 2018-04-10 17:32:50 Suggest the best values for the postgres configuration parameters