Hi All,
I am facing an issue with wal recycling in one of my Postgresql servers running ina rhel box and the PG version is 10. The issue is that wal files are not recycling at all. Please note that its a qa server and the load is quite high on it. It is running in no archive mode with fsync on, max_wal_size is 8GB with checkpoint_timeout of 5mins and default checkpoint_completion_target of 0.5. Could you please give me some pointers what could be wrong, if it is hardware that is problem here, how can I collect some facts about it so that 8 can take this matter with system guys.
Average wal generation is approximately 9k per day
I have enabled log_checkpoint in my server and I can see it says checkpoint complete: wrote ###buffers, 0 wal files added, 0 removed, 0 recycled,,,, LogCheckpointEnd
I have no active replication slots in this database cluster.Also the wal_keep_segments is set to 0. Appreciate your help!
Thanks,
Rijo Roy