X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CE85D11F65EB for ; Fri, 31 Mar 2006 11:48:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41989-08 for ; Fri, 31 Mar 2006 11:47:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id C0FBE11F66BE for ; Fri, 31 Mar 2006 11:47:52 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id CC69556427; Fri, 31 Mar 2006 09:47:53 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Fri, 31 Mar 2006 09:47:53 -0600 Date: Fri, 31 Mar 2006 09:47:53 -0600 From: "Jim C. Nasby" To: stef Cc: Chris , pgsql-performance@postgresql.org Subject: Re: simple join uses indexes, very slow Message-ID: <20060331154752.GN49405@pervasive.com> References: <20060327134733.72422d23.gry@ll.mit.edu> <442A1808.6090705@gmail.com> <442A244F.4030203@ummon.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <442A244F.4030203@ummon.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060331:stef@ummon.com::Q6ANBOzzu/n/dQAG:0000Zer X-Hashcash: 1:20:060331:dmagick@gmail.com::NyWcjnX4cq3RNd1J:00000000000000000000 00000000000000000000000037kp X-Hashcash: 1:20:060331:pgsql-performance@postgresql.org::Bl3YLu1E02iglKhl:00000 0000000000000000000000004nea X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/638 X-Sequence-Number: 18075 On Wed, Mar 29, 2006 at 01:08:15AM -0500, stef wrote: > > If your looking for suggestions, I would suggest updating the 8.1.x you > have installed to the latest version, as of typing this is 8.1.3 ;) Most > notable is some of the -bug- fixes that are in since 8.1.0, for example; > > * Fix incorrect optimizations of outer-join conditions (Tom) > > You know, minor point releases aren't adding new features or changing > basic functionality, they are pure and simple bugfixes. If I was in > -your- position, I would run (don't walk ;) and install upto 8.1.3 More important, there are data loss bugfixes between 8.1.0 and 8.1.3. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461