Re: 100% CPU Utilization when we run queries.

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: bakkiya <bakkiya(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 100% CPU Utilization when we run queries.
Date: 2011-06-10 09:00:59
Message-ID: BANLkTim9BuBaC_MU3Py6NAmaERmibcXc8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Jun 8, 2011 at 07:19, bakkiya <bakkiya(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Klemme 2011-06-10 10:02:50 Re: [GENERAL] [PERFORMANCE] expanding to SAN: which portion best to move
Previous Message anthony.shipman 2011-06-10 08:38:39 Re: strange query plan with LIMIT