Re: Postmaster only takes 4-5% CPU

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