Re: Simple join optimized badly?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>, "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
Subject: Re: Simple join optimized badly?
Date: 2006-10-09 17:12:43
Message-ID: 200610091012.43855.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-10-09 17:41:42 Re: Simple join optimized badly?
Previous Message Medora Schauer 2006-10-09 14:27:30 Re: autovacuum not working?