Re: *_collapse_limit, geqo_threshold

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: *_collapse_limit, geqo_threshold
Дата
Msg-id 19649.1247112389@sss.pgh.pa.us
обсуждение исходный текст
Ответ на *_collapse_limit, geqo_threshold  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Noah Misch <noah@leadboat.com> writes:
> Describing in those terms illuminates much.  While the concepts do suggest 2^N
> worst-case planning cost, my artificial test case showed a rigid 4^N pattern;
> what could explain that?

Well, the point of the 2^N concept is just that adding one more relation
multiplies the planning work by a constant factor.  It's useful data
that you find the factor to be about 4, but I wouldn't have expected the
model to tell us that.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: *_collapse_limit, geqo_threshold
Следующее
От: Greg Smith
Дата:
Сообщение: Re: multi-threaded pgbench