Message-ID: <48AC8292.5000708@ecomtecnologia.com.br>
Date: Wed, 20 Aug 2008 17:46:10 -0300
From: =?ISO-8859-1?Q?Andr=E9_Volpato?=
 <andre.volpato@ecomtecnologia.com.br>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Postgres not using array
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable


David Wilson escreveu:
> On Wed, Aug 20, 2008 at 2:30 PM, Andr=E9 Volpato
> <andre.volpato@ecomtecnologia.com.br> wrote:
>
>  =20
>> The CPU is 100% used since a few hours ago. Can anyone tell why?
>>    =20
>
> 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.
>  =20

The query itself runs smoothly, almost with no delay.

I am into some serious hardware fault. The application runs the query,=20
and store the results
like text files in another server. For some reason, the query pid=20
remains active
in the dbserver, and taking 100% CPU.

I=B4m gonna dig a little more.
Maybe the application is not able to store the results, or something.

--=20

[]=B4s, ACV