Re: Postmaster only takes 4-5% CPU

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

--
Jamie Lawrence jal(at)jal(dot)org
"Many and loud have been the voices crying that Aids was God's
way of punishing an unnatural practice. One day, perhaps, an
inoculation against HIV may be discovered. A bottle of champagne,
then, for whoever cites me evidence of one of those voices
crying that the breakthrough is God's way of telling us to
bugger each other."
- Matthew Parris