X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7588A9FA5E7 for ; Tue, 20 Jun 2006 23:56:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 55793-08 for ; Tue, 20 Jun 2006 23:56:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.194]) by postgresql.org (Postfix) with ESMTP id 7F5109FA5E6 for ; Tue, 20 Jun 2006 23:56:34 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id n1so58061nzf for ; Tue, 20 Jun 2006 19:56:32 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jvEbo9/flDKRfbMeiKV4RWDXUjRBxq0bWC822jQRO7IJ+e29H9nyc4IEwbKoms5KufkRtAB0PpeSrsyL4xPL4OTFJeC35L8ywu3uECjnnglBD2mXya9EOnMdZafnmJXtnIwN+E43sf3/U8gf6x8rJEJLRQa4IOry7pe/1uhJA4o= Received: by 10.65.251.1 with SMTP id d1mr161734qbs; Tue, 20 Jun 2006 19:56:32 -0700 (PDT) Received: by 10.65.139.14 with HTTP; Tue, 20 Jun 2006 19:56:32 -0700 (PDT) Message-ID: Date: Tue, 20 Jun 2006 22:56:32 -0400 From: "Merlin Moncure" To: "Merkel Marcel (CR/AEM4)" Subject: Re: Big array speed issues Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=WINDOWS-1252; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/389 X-Sequence-Number: 19746 On 6/20/06, Merkel Marcel (CR/AEM4) wrote: > I use libpqxx to access the database. This might be another bottleneck, b= ut > I assume my query and table setup is the bigger bottleneck. Would it make > sense to fetch the whole array ? (Select map from table where =85 and pa= rse > the array manually) have you tried similar approach without using arrays? merlin