Postgres Pro
Downloads
Home   >   mailing lists

Re: 100% CPU Utilization when we run queries. - Mailing list pgsql-performance

From Marti Raudsepp
Subject Re: 100% CPU Utilization when we run queries.
Date
Msg-id BANLkTim9BuBaC_MU3Py6NAmaERmibcXc8w@mail.gmail.com
Whole thread Raw
In response to 100% CPU Utilization when we run queries.  (bakkiya <bakkiya@gmail.com>)
List pgsql-performance
Tree view 
On Wed, Jun 8, 2011 at 07:19, bakkiya <bakkiya@gmail.com> 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 by date:

Previous
From: anthony.shipman@symstream.com
Date:
Subject: Re: strange query plan with LIMIT
Next
From: Robert Klemme
Date:
Subject: Re: [GENERAL] [PERFORMANCE] expanding to SAN: which portion best to move