We are using PostgreSQL 9.2 version.
As you requested below you can find the checkpoint parameter values. In pg_xlog directory , I can see each wal file size is 16mb.
select name, setting from pg_settings where name IN ('checkpoint_segments','checkpoint_timeout','max_wal_size','min_wal_size','checkpoint_completion_target','wal_keep_segments');
Hi Raghavendra,
Please let us know your PostgreSQL version.
Also, what are the values set to the following parameters ?
select name, setting from pg_settings where name IN ('checkpoint_segments','checkpoint_timeout','max_wal_size','min_wal_size','checkpoint_completion_target','wal_keep_segments');
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425