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

From Jim C. Nasby
Subject Re: FW: Simple join optimized badly?
Date
Msg-id 20061012163747.GG28647@nasby.net
Whole thread Raw
In response to Re: FW: Simple join optimized badly?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: FW: Simple join optimized badly?  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-performance
On Thu, Oct 12, 2006 at 10:44:20AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jim@nasby.net> writes:
> > If someone's going to commit to putting effort into improving the
> > planner then that's wonderful. But I can't recall any significant
> > planner improvements since min/max (which I'd argue was more of a bug
> > fix than an improvement).
>
> Hmph.  Apparently I've wasted most of the last five years.

Ok, now that I've actually looked at the release notes, I take that back
and apologize. But while there's a lot of improvements that have been
made, there's still some seriously tough problems that have been talked
about for a long time and there's still no "light at the end of the
tunnel", like how to handle multi-column statistics.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Hints proposal
Next
From: "Bucky Jordan"
Date:
Subject: Re: Hints proposal