Re: *_collapse_limit, geqo_threshold

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: *_collapse_limit, geqo_threshold
Дата
Msg-id 26994.1246995924@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: *_collapse_limit, geqo_threshold  (Dimitri Fontaine <dfontaine@hi-media.com>)
Ответы Re: *_collapse_limit, geqo_threshold  (Dimitri Fontaine <dfontaine@hi-media.com>)
Список pgsql-hackers
Dimitri Fontaine <dfontaine@hi-media.com> writes:
> Another idea would be to have more complex metrics for deciding when  
> to run geqo, that is guesstimate the query planning difficulty very  
> quickly, based on more than just the number of relations in the from:  
> presence of subqueries, UNION, EXISTS, IN, or branches in where  
> clause, number of operators and index support for them, maybe some  
> information from the stats too...

Pointless, since GEQO is only concerned with examining alternative join
orderings.  I see no reason whatever to think that number-of-relations
isn't the correct variable to test to decide whether to use it.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [pgsql-www] commitfest.postgresql.org
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Maintenance Policy?