My CPU usage remains over 50% with Postgre

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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP
Следующее
От: Colin Wetherbee
Дата:
Сообщение: Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP