Message-ID: <4529B7E8.8080606@modgraph-usa.com>
Date: Sun, 08 Oct 2006 19:46:00 -0700
From: "Craig A. James" <cjames@modgraph-usa.com>
User-Agent: Thunderbird 1.5.0.7 (X11/20060909)
MIME-Version: 1.0
To: Mark Kirkwood <markir@paradise.net.nz>, pgsql-performance@postgresql.org
Subject: Re: Simple join optimized badly?
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>
In-Reply-To: <4529B6D0.2010206@paradise.net.nz>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mark Kirkwood wrote:
>> The result?  I can't use my function in any WHERE clause that involves 
>> any other conditions or joins.  Only by itself.  PG will occasionally 
>> decide to use my function as a filter instead of doing the join or the 
>> other WHERE conditions first, and I'm dead.
> 
> this is an argument for cost-for-functions rather than hints AFAICS.

Perhaps you scanned past what I wrote a couple paragraphs farther down.  I'm going to repeat it because it's the KEY POINT I'm trying to make:

Craig James wrote:
> Now you might argue that function-cost needs to be added to the 
> optimizer's arsenal of tricks.  And I'd agree with you: That WOULD be a 
> better solution than hints.  But I need my problem solved TODAY, not 
> next year.  Hints can help solve problems NOW that can be brought to the 
> PG team's attention later, and in the mean time let me get my 
> application to work.

Craig