Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E9DEA9FA5D3 for ; Fri, 13 Oct 2006 14:30:45 -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 24613-06 for ; Fri, 13 Oct 2006 14:30:28 -0300 (ADT) 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 A26049FB4F2 for ; Fri, 13 Oct 2006 14:30:27 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 5A06956435; Fri, 13 Oct 2006 12:30:26 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Fri, 13 Oct 2006 12:30:24 -0500 Date: Fri, 13 Oct 2006 12:30:24 -0500 From: "Jim C. Nasby" To: Jeff Davis Cc: Bucky Jordan , Alvaro Herrera , josh@agliodbs.com, pgsql-hackers@postgresql.org Subject: Re: [PERFORM] Hints proposal Message-ID: <20061013173024.GE28647@nasby.net> References: <78ED28FACE63744386D68D8A9D1CF5D4209CBD@MAIL.corp.lumeta.com> <1160760211.31966.231.camel@dogma.v10.wvs> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1160760211.31966.231.camel@dogma.v10.wvs> 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:061013:pgsql@j-davis.com::QfTmedHQUXpo5voR:00000000000000000000 0000000000000000000000001zZU X-Hashcash: 1:20:061013:bjordan@lumeta.com::nXqUOLX52zDoFZsN:0000000000000000000 0000000000000000000000008FgV X-Hashcash: 1:20:061013:alvherre@commandprompt.com::/Wcr3nR+CF1ZTa6D:00000000000 0000000000000000000000002GX6 X-Hashcash: 1:20:061013:josh@agliodbs.com::VZ4xyi4/+a8CRPqu:00000000000000000000 0000000000000000000000000Apl X-Hashcash: 1:20:061013:pgsql-hackers@postgresql.org::5Bixg8zWWSdbOCgC:000000000 0000000000000000000000005BmP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200610/770 X-Sequence-Number: 92667 On Fri, Oct 13, 2006 at 10:23:31AM -0700, Jeff Davis wrote: > Right. And I think the sane ideas are along the lines of estimate & cost > corrections (like Tom is saying). Let me ask this... how long do you (and others) want to wait for those? It's great that the planner is continually improving, but it also appears that there's still a long road ahead. Having a dune-buggy to get to your destination ahead of the road might not be a bad idea... :) -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)