Re: My CPU usage remains over 50% with Postgre

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guillermo Arias <guillermoariast(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: My CPU usage remains over 50% with Postgre
Date: 2008-03-14 00:02:54
Message-ID: 27683.1205452974@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Guillermo Arias <guillermoariast(at)gmail(dot)com> writes:
> Hello, i have a problem with Postgre.
> When i perform a query Postgre do it all right, but CPU usage remains
> over 50%, even if i finished with queries.
> I try rebooting the pc, it works fine; for some time i have around 1%
> to 5% of cpu usage, but if i start other query it raises to 50% and
> keep it allways. If i perform another query, cpu usage raises to 100%.

What process is eating the cycles?

If this is an early 8.2.x release and it's the stats collector process,
this is a known bug --- update.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-03-14 00:08:27 Re: postgre vs MySQL
Previous Message Sushant Sinha 2008-03-13 23:56:07 tsearch2 word separators