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 A0F249FB202 for ; Thu, 27 Jul 2006 11:52:41 -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 06593-05 for ; Thu, 27 Jul 2006 11:52:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.199]) by postgresql.org (Postfix) with ESMTP id 7784F9FA68D for ; Thu, 27 Jul 2006 11:52:33 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id n29so63989nzf for ; Thu, 27 Jul 2006 07:52:31 -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=inuBPcp0U9JyZu5RCghRkithovGZW+Suf+VSDKx+LEmTNpgD65p8Sdb1mySMiqJQ0sHyFWmX4LsYRYvHhjpBjwO05VZpejT4K8/EDEtneOVO668X1z/HXoc8xfOOlSLV+kZxQrLp6+7q/VR3xug5G/+VRl8EBNuy26yWhfDJeio= Received: by 10.65.138.4 with SMTP id q4mr9052678qbn; Thu, 27 Jul 2006 07:52:31 -0700 (PDT) Received: by 10.65.139.10 with HTTP; Thu, 27 Jul 2006 07:52:31 -0700 (PDT) Message-ID: Date: Thu, 27 Jul 2006 10:52:31 -0400 From: "Merlin Moncure" To: Eliott Subject: Re: performance issue with a specific query Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.209 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/243 X-Sequence-Number: 20103 On 7/27/06, Eliott wrote: > Hi! > > I hope I'm sending my question to the right list, please don't flame if it's > the wrong one. > > I have noticed that while a query runs in about 1.5seconds on a 8.xx version > postgresql server on our 7.4.13 it takes around 15-20 minutes. Since we are > using RHEL4 on our server we are stuck with 7.4.13. The enormous time > difference between the different builds drives me crazy. Can you please help > me identifying the bottleneck or suggest anything to improve the dismal > performance. > The query is the following: > try turning off genetic query optimization. regarding the rhel4 issue...does rhel not come with a c compiler? :) merlin