Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3BB679FA6B2 for ; Thu, 12 Oct 2006 13:37:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 32115-08 for ; Thu, 12 Oct 2006 16:37:49 +0000 (UTC) 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 4B4AA9FB399 for ; Thu, 12 Oct 2006 13:37:49 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 9494356437; Thu, 12 Oct 2006 11:37:48 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 12 Oct 2006 11:37:47 -0500 Date: Thu, 12 Oct 2006 11:37:47 -0500 From: "Jim C. Nasby" To: Tom Lane Cc: Mark Kirkwood , "H.J. Sanders" , pgsql-performance@postgresql.org Subject: Re: FW: Simple join optimized badly? Message-ID: <20061012163747.GG28647@nasby.net> References: <452E11FB.7070704@paradise.net.nz> <20061012135248.GS28647@nasby.net> <10362.1160664260@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <10362.1160664260@sss.pgh.pa.us> 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:061012:tgl@sss.pgh.pa.us::yqQmAsVzv2I8nAXl:00000000000000000000 0000000000000000000000002OD2 X-Hashcash: 1:20:061012:markir@paradise.net.nz::7Nwzv0F+Q29xi79A:000000000000000 0000000000000000000000001jPb X-Hashcash: 1:20:061012:hjs@rmax.nl::zb+usuB0A+oFkJZI:0000001rlu X-Hashcash: 1:20:061012:pgsql-performance@postgresql.org::Tz6CSi2EyyN0TLw0:00000 0000000000000000000000004nrp X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/242 X-Sequence-Number: 21371 On Thu, Oct 12, 2006 at 10:44:20AM -0400, Tom Lane wrote: > "Jim C. Nasby" writes: > > If someone's going to commit to putting effort into improving the > > planner then that's wonderful. But I can't recall any significant > > planner improvements since min/max (which I'd argue was more of a bug > > fix than an improvement). > > Hmph. Apparently I've wasted most of the last five years. Ok, now that I've actually looked at the release notes, I take that back and apologize. But while there's a lot of improvements that have been made, there's still some seriously tough problems that have been talked about for a long time and there's still no "light at the end of the tunnel", like how to handle multi-column statistics. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)