From: Craig A. James <cjames@modgraph-usa.com>
To: Mark Kirkwood <markir@paradise.net.nz>
To: pgsql-performance@postgresql.org
Subject: Re: Simple join optimized badly?
Date: Sun, 08 Oct 2006 19:46:00 -0700
Message-ID: <4529B7E8.8080606@modgraph-usa.com> (raw)
In-Reply-To: <4529B6D0.2010206@paradise.net.nz>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cjames@modgraph-usa.com, markir@paradise.net.nz
Subject: Re: Simple join optimized badly?
In-Reply-To: <4529B7E8.8080606@modgraph-usa.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox