My CPU usage remains over 50% with Postgre

Started by Guillermo Ariasabout 18 years ago2 messagesgeneral
Jump to latest
#1Guillermo Arias
guillermoariast@gmail.com

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 can i do?

Guillermo

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Guillermo Arias (#1)
Re: My CPU usage remains over 50% with Postgre

Guillermo Arias <guillermoariast@gmail.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