Re: Postgres not using array

From: "David Wilson" <david(dot)t(dot)wilson(at)gmail(dot)com>
To: André Volpato <andre(dot)volpato(at)ecomtecnologia(dot)com(dot)br>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres not using array
Date: 2008-08-20 20:02:01
Message-ID: e7f9235d0808201302v1ebe732fjbb6bbf17cf69eed3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Aug 20, 2008 at 2:30 PM, André Volpato
<andre(dot)volpato(at)ecomtecnologia(dot)com(dot)br> wrote:

> The CPU is 100% used since a few hours ago. Can anyone tell why?

Sounds like you've just got a CPU bound query. The data may even all
be in cache.

Some information on database size, along with EXPLAIN results for your
queries, would help here.

--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message André Volpato 2008-08-20 20:46:10 Re: Postgres not using array
Previous Message André Volpato 2008-08-20 18:30:25 Postgres not using array