Re: planner missing a trick for foreign tables w/OR conditions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: planner missing a trick for foreign tables w/OR conditions
Дата
Msg-id 14601.1387308018@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: planner missing a trick for foreign tables w/OR conditions  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Dec 17, 2013 at 12:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> (I wonder if it'd be worth inserting a check that
>> there's not already a manually-generated equivalent clause, too ...)

> Sounds a little too clever IMHO.

The argument for doing it is that we might otherwise find ourselves
degrading the plans for previously-manually-optimized queries.  On the
other hand, the existing index-driven code has probably forestalled the
need for many people to do that; at least, I don't recall seeing much
discussion of doing that sort of thing by hand.

I'm happy to leave the issue out of the first version of the patch,
anyway.
        regards, tom lane



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: SSL: better default ciphersuite
Следующее
От: Tom Lane
Дата:
Сообщение: Re: planner missing a trick for foreign tables w/OR conditions