| From: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com> |
|---|---|
| To: | uwcssa <uwcssa(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: postgresql geqo optimization |
| Date: | 2006-02-11 01:52:06 |
| Message-ID: | 20060211015206.GA19612@uio.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, Feb 10, 2006 at 08:46:14PM -0500, uwcssa wrote:
> I am wondering if anyone here ever had complex queries that the GEQO fails
> to work properly, i.e., finds a terrible query plan as compared to one
> found by DP optimizer (by forcing Postgresql always uses DP). This is
> important to me since I am trying to see what type of queries will be worth
> spending a lot of time doing a thorough DP optimization (if it is going to
> be executed again and again).
There have been a few problems earlier on this list which might have been the
geqo's fault; search the list archives for "geqo" or "genetic", and you
should be able to find them quite easily.
/* Steinar */
--
Homepage: http://www.sesse.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2006-02-11 01:57:28 | Re: What do the Windows pg hackers out there like for dev |
| Previous Message | uwcssa | 2006-02-11 01:46:14 | postgresql geqo optimization |