Re: Predicates not getting pushed into SQL function?

From: Jay Levitt <jay(dot)levitt(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Predicates not getting pushed into SQL function?
Date: 2011-11-07 20:15:23
Message-ID: 4EB83C5B.3020103@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2011-11-07 20:26:13 Re: Blocking excessively in FOR UPDATE
Previous Message Jay Levitt 2011-11-07 20:13:43 Re: Predicates not getting pushed into SQL function?