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@jal.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