Adrian Moisey wrote:
If I tail the logs, I see a steady stream of functions that took longer then 5 seconds. But every now and then I see nothing for 3 minutes and after that a whole bunch (about 20 - 30) queries all finishing at the same second.
Search this list for references to "checkpoints". If you run vmstat/iostat for a bit you should see bursts of disk activity at those times.
Counter-intuitively you probably want *more* checkpoints (with less data to write out each time), but see the list archives for discussion. Also check the manuals for some background info.
HTH -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
