Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 9DBA39FB462
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 10 Oct 2006 21:37:07 -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 22125-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 10 Oct 2006 21:37:03 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from linda-1.paradise.net.nz (linda-1.paradise.net.nz
	[203.96.152.180])
	by postgresql.org (Postfix) with ESMTP id 54EE99FB46D
	for <pgsql-performance@postgresql.org>;
	Tue, 10 Oct 2006 21:37:03 -0300 (ADT)
Received: from smtp-1.paradise.net.nz
	(tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by
	linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id
	<0J6Y00FV94DLY7@linda-1.paradise.net.nz> for
	pgsql-performance@postgresql.org; Wed, 11 Oct 2006 13:36:57 +1300 (NZDT)
Received: from [192.168.1.11]
	(218-101-28-176.dsl.clear.net.nz [218.101.28.176])	by
	smtp-1.paradise.net.nz (Postfix) with ESMTP id 9CA6793AFBA;
	Wed, 11 Oct 2006 13:36:56 +1300 (NZDT)
Date: Wed, 11 Oct 2006 13:36:39 +1300
From: Mark Kirkwood <markir@paradise.net.nz>
Subject: Re: Simple join optimized badly?
In-reply-to: <452C3C2D.6000008@paradise.net.nz>
To: Mark Kirkwood <markir@paradise.net.nz>
Cc: "Jim C. Nasby" <jim@nasby.net>, Chris Browne <cbbrowne@acm.org>,
	pgsql-performance@postgresql.org
Message-id: <452C3C97.5060803@paradise.net.nz>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7bit
User-Agent: Thunderbird 1.5.0.7 (X11/20061003)
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>
	<452C3C2D.6000008@paradise.net.nz>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.036 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200610/214
X-Sequence-Number: 21343

Mark Kirkwood wrote:

> who believe it is possible to build a "start enough" optimizer.
> 
That's meant to read "smart enough" optimizer .. sorry.