Re: anti-join chosen even when slower than old plan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: anti-join chosen even when slower than old plan
Дата
Msg-id 17688.1289497551@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: anti-join chosen even when slower than old plan  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Ответы Re: anti-join chosen even when slower than old plan  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Re: anti-join chosen even when slower than old plan  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-performance
Mladen Gogala <mladen.gogala@vmsinfo.com> writes:
> Again, having an optimizer which will choose the plan completely
> accurately is, at least in my opinion, less important than having a
> possibility of manual control, the aforementioned "knobs and buttons"
> and produce the same plan for the same statement.

More knobs and buttons is the Oracle way, and the end result of that
process is that you have something as hard to use as Oracle.  That's
generally not thought of as desirable in this community.

            regards, tom lane

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: anti-join chosen even when slower than old plan
Следующее
От: Craig James
Дата:
Сообщение: Re: anti-join chosen even when slower than old plan