From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Mark Kirkwood <markir@paradise.net.nz>
Cc: Craig A. James <cjames@modgraph-usa.com>
Subject: Re: Simple join optimized badly?
Date: Mon, 9 Oct 2006 10:12:43 -0700
Message-ID: <200610091012.43855.josh@agliodbs.com> (raw)
In-Reply-To: <19817.1160369035@sss.pgh.pa.us>
References: <45274A77.7080005@modgraph-usa.com>
<4529C43A.3050503@paradise.net.nz>
<19817.1160369035@sss.pgh.pa.us>
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
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: josh@agliodbs.com, tgl@sss.pgh.pa.us, markir@paradise.net.nz, cjames@modgraph-usa.com
Subject: Re: Simple join optimized badly?
In-Reply-To: <200610091012.43855.josh@agliodbs.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