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 206899FB21A for ; Thu, 27 Jul 2006 15:24:12 -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 37038-04-2 for ; Thu, 27 Jul 2006 15:23:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B525C9FB20B for ; Thu, 27 Jul 2006 15:23:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from alvh.no-ip.org (200-126-100-4.bk7-dsl.surnet.cl [200.126.100.4]) by svr4.postgresql.org (Postfix) with ESMTP id 4FF335AFB4E for ; Thu, 27 Jul 2006 17:27:42 +0000 (GMT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id 62995C2F85A; Thu, 27 Jul 2006 13:25:48 -0400 (CLT) Date: Thu, 27 Jul 2006 13:25:48 -0400 From: Alvaro Herrera To: "Joshua D. Drake" Cc: Merlin Moncure , Eliott , pgsql-performance@postgresql.org Subject: Re: performance issue with a specific query Message-ID: <20060727172548.GD18774@surnet.cl> Mail-Followup-To: "Joshua D. Drake" , Merlin Moncure , Eliott , pgsql-performance@postgresql.org References: <44C8DE3E.4060208@commandprompt.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44C8DE3E.4060208@commandprompt.com> User-Agent: Mutt/1.5.12-2006-07-14 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.903 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200607/245 X-Sequence-Number: 20105 Joshua D. Drake wrote: > >> > > > >try turning off genetic query optimization. regarding the rhel4 > >issue...does rhel not come with a c compiler? :) > > Enterprises are not going to compile. They are going to accept the > latest support by vendor release. > > Redhat has a tendency to be incredibly stupid about this particular > area of their packaging. Stupid how? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support