Postgres Pro
Downloads
Home   >   mailing lists

difference between checkpoint_segments and wal_keep_segments inpostgres configuration file - Mailing list pgsql-general

From Raghavendra Rao J S V
Subject difference between checkpoint_segments and wal_keep_segments inpostgres configuration file
Date
Msg-id CAEHH7R7dSEka9StaNaHPV=72NLHfBkBreC2pqihWzCi-LRysng@mail.gmail.com
Whole thread Raw
Responses Re: difference between checkpoint_segments and wal_keep_segments inpostgres configuration file
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Raghavendra Rao J S V
Date:
Subject: Suggest the best values for the postgres configuration parameters
Next
From: Raghavendra Rao J S V
Date:
Subject: Planning to change autovacuum_vacuum_scale_factor value to zero.Please suggest me if any negative impact.