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"