From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: uwcssa <uwcssa@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql geqo optimization
Date: Sat, 11 Feb 2006 02:52:06 +0100
Message-ID: <20060211015206.GA19612@uio.no> (raw)
In-Reply-To: <f2f562510602101746g2542a08aod0bbb16787f4eb31@mail.gmail.com>
References: <f2f562510602101746g2542a08aod0bbb16787f4eb31@mail.gmail.com>
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/
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: sgunderson@bigfoot.com, uwcssa@gmail.com
Subject: Re: postgresql geqo optimization
In-Reply-To: <20060211015206.GA19612@uio.no>
* 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