If I have a system that writes out one WAL file every 5 minutes, and I
have these settings:
checkpoint_timeout = 3329
checkpoint_segments = 1000
(parameters checked as valid via pg_settings)
How many WAL files would you expect to see in pg_xlog, once the system
has reached steady state?
I would expect checkpoints to occur every 3329 seconds, giving on
average 10-11 WAL files per checkpoint. So, I expect to find up to 23
WAL files in the pg_xlog directory.
I have 308 files in pg_xlog, which remains constant. The oldest file
time is approximately 24 hours ago.
Am I just tired, or is that a little strange?
pg 7.4.6
Best Regards, Simon Riggs