Re: 100% CPU Utilization when we run queries.

Поиск
Список
Период
Сортировка
Искать
От
Marti Raudsepp
Тема
Re: 100% CPU Utilization when we run queries.
Дата
Msg-id
BANLkTim9BuBaC_MU3Py6NAmaERmibcXc8w@mail.gmail.com
Ответ на
100% CPU Utilization when we run queries. (bakkiya)
Список
Дерево обсуждения
100% CPU Utilization when we run queries. bakkiya <bakkiya@gmail.com>
Re: 100% CPU Utilization when we run queries. Craig Ringer <craig@postnewspapers.com.au>
Re: 100% CPU Utilization when we run queries. bakkiya <bakkiya@gmail.com>
Re: 100% CPU Utilization when we run queries. Craig Ringer <craig@postnewspapers.com.au>
Re: 100% CPU Utilization when we run queries. bakkiya <bakkiya@gmail.com>
Re: 100% CPU Utilization when we run queries. bakkiya <bakkiya@gmail.com>
Re: 100% CPU Utilization when we run queries. "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: 100% CPU Utilization when we run queries. Tomas Vondra <tv@fuzzy.cz>
Re: 100% CPU Utilization when we run queries. Craig Ringer <craig@postnewspapers.com.au>
Re: 100% CPU Utilization when we run queries. bakkiya <bakkiya@gmail.com>
Re: 100% CPU Utilization when we run queries. Robert Klemme <shortcutter@googlemail.com>
Re: 100% CPU Utilization when we run queries. Scott Marlowe <scott.marlowe@gmail.com>
Re: 100% CPU Utilization when we run queries. Marti Raudsepp <marti@juffo.org> 
On Wed, Jun 8, 2011 at 07:19, bakkiya  wrote:
> We have a postgresql 8.3.8 DB which consumes 100% of the CPU whenever we run
> any query. We got vmstat output Machine details are below:

Any query? Does even "SELECT 1" not work? Or "SELECT * FROM sometable LIMIT 1"

Or are you having problems with only certain kinds of queries? If so,
please follow this for how to report it:
https://wiki.postgresql.org/wiki/SlowQueryQuestions

Regards,
Marti
В списке pgsql-performance по дате отправления
Предыдущее
От: anthony.shipman@symstream.com
Дата:
Следующее
От: Robert Klemme
Дата:
FAQ