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