Re: postgresql geqo optimization

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: postgresql geqo optimization
Дата
Msg-id 20060211015206.GA19612@uio.no
обсуждение исходный текст
Ответ на postgresql geqo optimization  (uwcssa <uwcssa@gmail.com>)
Список 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/

В списке pgsql-performance по дате отправления:

Предыдущее
От: uwcssa
Дата:
Сообщение: postgresql geqo optimization
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: [HACKERS] What do the Windows pg hackers out there like for dev