Re: [PERFORM] strange pauses

2008-01-16 Thread Adrian Moisey
Hi 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. The most straightforward way to prove or disprove that the slow queries line up with checkpoints is to set to checkpoint_warning to a high value (36

Re: [PERFORM] strange pauses

2008-01-16 Thread Greg Smith
On Wed, 16 Jan 2008, Richard Huxton wrote: 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. The most straightforward way to prove or disprove that the slow queries line up with checkpoints is to set to

Re: [PERFORM] strange pauses

2008-01-16 Thread Scott Marlowe
On Jan 16, 2008 4:42 AM, Adrian Moisey <[EMAIL PROTECTED]> wrote: > Hi > > I've noticed a strange pattern in our logs. > > We only log anything that takes longer then 5 seconds. > > If I tail the logs, I see a steady stream of functions that took longer > then 5 seconds. But every now and then I s

Re: [PERFORM] strange pauses

2008-01-16 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> writes: > 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

Re: [PERFORM] strange pauses

2008-01-16 Thread Richard Huxton
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 "checkpo

[PERFORM] strange pauses

2008-01-16 Thread Adrian Moisey
Hi I've noticed a strange pattern in our logs. We only log anything that takes longer then 5 seconds. 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) querie