Re: My CPU usage remains over 50% with Postgre

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: My CPU usage remains over 50% with Postgre
Дата
Msg-id 27683.1205452974@sss.pgh.pa.us
обсуждение исходный текст
Ответ на My CPU usage remains over 50% with Postgre  (Guillermo Arias <guillermoariast@gmail.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Sushant Sinha
Дата:
Сообщение: tsearch2 word separators
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgre vs MySQL