Re: Simple join optimized badly? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Simple join optimized badly?
Date
Msg-id 200610091012.43855.josh@agliodbs.com
Whole thread Raw
In response to Re: Simple join optimized badly?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Simple join optimized badly?
List 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

pgsql-performance by date:

Previous
From: "Medora Schauer"
Date:
Subject: Re: autovacuum not working?
Next
From: Tom Lane
Date:
Subject: Re: Simple join optimized badly?