From: Josh Berkus <josh@agliodbs.com>
Organization: PostgreSQL @ Sun
To: pgsql-performance@postgresql.org
Subject: Re: Simple join optimized badly?
Date: Mon, 9 Oct 2006 10:12:43 -0700
User-Agent: KMail/1.8.2
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Mark Kirkwood <markir@paradise.net.nz>,
	"Craig A. James" <cjames@modgraph-usa.com>
References: <45274A77.7080005@modgraph-usa.com>
	<4529C43A.3050503@paradise.net.nz> <19817.1160369035@sss.pgh.pa.us>
In-Reply-To: <19817.1160369035@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200610091012.43855.josh@agliodbs.com>

Tom,

> Josh's post points out some reasons why it's not that easy to get
> long-term benefits from hints --- you could possibly address some of
> those problems, but a hint language that responds to those criticisms
> won't be trivial to design, implement, or maintain.  See (many) past
> discussions for reasons why not.

Well, why don't we see what EDB can come up with?   If it's not "good enough" 
we'll just reject it.  

Unfortunately, EDB's solution is likely to be Oracle-based, which is liable to 
fall into the trap of "not good enough."

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco