Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 851049FB2BF for ; Mon, 9 Oct 2006 19:40:15 -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 36308-03 for ; Mon, 9 Oct 2006 22:39:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 8E98A9FB2A9 for ; Mon, 9 Oct 2006 19:39:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k99MdtA4009671; Mon, 9 Oct 2006 18:39:56 -0400 (EDT) To: "Jim C. Nasby" cc: Chris Browne , pgsql-performance@postgresql.org Subject: Re: Simple join optimized badly? In-reply-to: <20061009211827.GL72517@nasby.net> References: <45274A77.7080005@modgraph-usa.com> <18722.1160236300@sss.pgh.pa.us> <5f820f750610071850o6ed0b19o162d65d1987b2a8c@mail.gmail.com> <200610081605.03501.josh@agliodbs.com> <4529A0CA.8000904@modgraph-usa.com> <4529B6D0.2010206@paradise.net.nz> <4529B7E8.8080606@modgraph-usa.com> <604pud8ise.fsf@dba2.int.libertyrms.com> <20061009211827.GL72517@nasby.net> Comments: In-reply-to "Jim C. Nasby" message dated "Mon, 09 Oct 2006 16:18:27 -0500" Date: Mon, 09 Oct 2006 18:39:55 -0400 Message-ID: <9670.1160433595@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/173 X-Sequence-Number: 21302 "Jim C. Nasby" writes: > I'll also say that a very simple hinting > language (ie: allowing you to specify access method for a table, and > join methods) would go a huge way towards enabling app developers to get > stuff done now while waiting for all these magical optimizer > improvements that have been talked about for years. Basically, the claim that it'll be both easy and useful is what I think is horsepucky ... let's see a detailed design if you think it's easy. regards, tom lane