Re: Postmaster only takes 4-5% CPU

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postmaster only takes 4-5% CPU
Date: 2003-05-29 13:47:41
Message-ID: 3ED65CD5.16997.52F1FD5@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 29 May 2003 at 13:24, Ruben wrote:
> When I run a (big) query from pgsql, postmaster used to take almost 100%
> of CPU. Now, with aparent no reason, Postmaster only takes 4-5% CPU and
> the same query takes really longer to finish.

Check vmstat when query is running. Is it saturating disk BW? If yes, have you
vacuummed the table/database recently?

HTH
Bye
Shridhar

--
Slurm, n.: The slime that accumulates on the underside of a soap bar when it
sits in the dish too long. -- Rich Hall, "Sniglets"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arjen van der Meijden 2003-05-29 13:50:06 Re: Postmaster only takes 4-5% CPU
Previous Message Kyle 2003-05-29 13:28:32 Re: change log 7.3.3