Re: Predicates not getting pushed into SQL function?

Поиск
Список
Период
Сортировка
От Jay Levitt
Тема Re: Predicates not getting pushed into SQL function?
Дата
Msg-id 4EB83C5B.3020103@gmail.com
обсуждение исходный текст
Ответ на Re: Predicates not getting pushed into SQL function?  (Jay Levitt <jay.levitt@gmail.com>)
Список pgsql-performance
Jay Levitt wrote:
> Yes, that patch works great! Oddly enough, the workaround now does NOT work;
> functions returning SETOF named composite types don't get inlined, but
> functions returning the equivalent TABLE do get inlined. Let me know if you
> need a failcase, but the bug doesn't actually affect me now :)

Never mind... I left a "strict" in my test.  Works great all around.

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

Предыдущее
От: Jay Levitt
Дата:
Сообщение: Re: Predicates not getting pushed into SQL function?
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Blocking excessively in FOR UPDATE