Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 79CC865041E for ; Wed, 20 Aug 2008 17:16:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28447-04-7 for ; Wed, 20 Aug 2008 17:16:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f17.google.com (mail-gx0-f17.google.com [209.85.217.17]) by postgresql.org (Postfix) with ESMTP id 8C7EC650485 for ; Wed, 20 Aug 2008 17:02:02 -0300 (ADT) Received: by gxk10 with SMTP id 10so95899gxk.19 for ; Wed, 20 Aug 2008 13:02:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=fRLdTvBHpPk1qfx1T4ObvmrpEN/EcXtlTWhgNC5gWS8=; b=BPvpR1XNy0XXYH8zEiWjDzT1YL0uhbgm0B4K6PcF+NVP0h4TrPnvLOqhiiH2Asfe1W iegm94QmLbdppSfftxab0l1c6ehcbuOwAkeKGuE2dYuY9SvuMzCkBI112cFBBsrzmnlW fPt/U1ZlQ41qK7VFyss1hyu2Bv9A2AROXGxZE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Abx662ot7SlZSpb/4xUSEpKHK8RxccZJ4y/MPQd0OyJDsWcJ6BtaFFRs2CGO2kA9fc qq/NRGx0dIkFSA++ZDtZIFt38ybG/UJf5LAHwlEXkFThMY6iwmtI67XXbOvPCSpy+/t4 FbbKFrqxYAtI4fGEfOVK11iPP4FOrOgVU2lBU= Received: by 10.150.206.11 with SMTP id d11mr669140ybg.140.1219262521667; Wed, 20 Aug 2008 13:02:01 -0700 (PDT) Received: by 10.150.134.10 with HTTP; Wed, 20 Aug 2008 13:02:01 -0700 (PDT) Message-ID: Date: Wed, 20 Aug 2008 16:02:01 -0400 From: "David Wilson" To: "=?ISO-8859-1?Q?Andr=E9_Volpato?=" Subject: Re: Postgres not using array Cc: pgsql-performance@postgresql.org In-Reply-To: <48AC62C1.9070209@ecomtecnologia.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <48AC62C1.9070209@ecomtecnologia.com.br> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/233 X-Sequence-Number: 31114 On Wed, Aug 20, 2008 at 2:30 PM, Andr=E9 Volpato 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. --=20 - David T. Wilson david.t.wilson@gmail.com