Thanks Jamie:
I'll send the output of vmstat next time this happens.
Ruben.
Jamie Lawrence wrote:
> On Fri, 06 Jun 2003, Ruben wrote:
>
>
>>Hi:
>>
>>I'm sorry to get back with this, but I claimed victory too soon.
>>Postmaster is back (intermitently) taking just a small % of cpu while
>>system is almost 100% idle, as you can see in "top" below.
>>
>>Any ideas of how can I fix this? Programs running queries are going too
>>slooooow.
>
>
>
>> 11:21am up 7 days, 21:00, 6 users, load average: 1,10, 1,04, 0,86
>>106 processes: 102 sleeping, 4 running, 0 zombie, 0 stopped
>>CPU states: 0,5% user, 1,7% system, 0,0% nice, 97,6% idle
>>Mem: 1031012K av, 1019052K used, 11960K free, 0K shrd, 11340K buff
>>Swap: 2040244K av, 153828K used, 1886416K free 958512K cached
>
>
> What does the output of 'vmstat 5 15' look like while you're running the
> query? (that command will run for 75 seconds.)
>
> I'm willing to bet your problem is I/O contention.
>
> -j
