Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DFC109FB28C for ; Mon, 16 Oct 2006 08:00:30 -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 55735-02 for ; Mon, 16 Oct 2006 08:00:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.envysolutions.com (mark.mielke.cc [206.248.142.186]) by postgresql.org (Postfix) with ESMTP id 24DF39FB1DF for ; Mon, 16 Oct 2006 08:00:25 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.envysolutions.com (Postfix) with ESMTP id DCBDF5403D; Mon, 16 Oct 2006 07:00:23 -0400 (EDT) X-Virus-Scanned: amavisd-new at mail.envysolutions.com Received: from mail.envysolutions.com ([127.0.0.1]) by localhost (mark.mielke.cc [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id dgzBvdUQ5UjR; Mon, 16 Oct 2006 07:00:23 -0400 (EDT) Received: by mail.envysolutions.com (Postfix, from userid 500) id A4AD25403E; Mon, 16 Oct 2006 07:00:23 -0400 (EDT) Date: Mon, 16 Oct 2006 07:00:23 -0400 From: mark@mark.mielke.cc To: "Craig A. James" Cc: pgsql-performance@postgresql.org Subject: Re: Hints proposal Message-ID: <20061016110023.GC6709@mark.mielke.cc> References: <78ED28FACE63744386D68D8A9D1CF5D4209CBF@MAIL.corp.lumeta.com> <4532D17B.20106@modgraph-usa.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4532D17B.20106@modgraph-usa.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.14 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, NO_REAL_NAME, SPF_HELO_PASS, SPF_PASS X-Spam-Level: * X-Archive-Number: 200610/288 X-Sequence-Number: 21417 On Sun, Oct 15, 2006 at 05:25:31PM -0700, Craig A. James wrote: > So my question is: Is there any argument that can be made to persuade those > of you who are volunteering your time on the optimizer to even consider a > HINTS proposal? Has all this discussion changed your perspective on 2(c), > and why it really matters to some of us? Are we just wasting our time, or > is this a fruitful discussion? They're waiting for an idea that captures their imagination. So far, it seems like a re-hashing of old ideas that have been previously shot down, none of which seem overly imaginative, or can be shown to provide significant improvement short term or long term... :-) Haha. That's my take on it. Sorry if it is harsh. To get very competent people to volunteer their time, you need to make them believe. They need to dream about it, and wake up the next morning filled with a desire to try out some of their ideas. You need to brain wash them... :-) Cheers, mark -- mark@mielke.cc / markm@ncf.ca / markm@nortel.com __________________________ . . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder |\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ | | | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada One ring to rule them all, one ring to find them, one ring to bring them all and in the darkness bind them... http://mark.mielke.cc/