Ho Fat Tsang wrote:
Hi Richard, I have tuned the checkpoint_timeout to 30 second which is ten times less than default and the issue is still reproduced. Do you have any recommended configuration for WAL ?
If you look at the output of "vmstat 10" and "iostat -m 10" (I'm assuming you're on Linux) does it show your I/O peaking every three minutes? I might have been wrong about the cause.
-- Richard Huxton Archonet Ltd