Re: LANGUAGE sql functions don't use the custom plan logic

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: LANGUAGE sql functions don't use the custom plan logic
Date: 2015-07-10 13:59:02
Message-ID: 20150710135902.GK26521@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2015-07-10 09:52:30 -0400, Tom Lane wrote:
> There's a whole lot of ways in which the current implementation of
> SQL-language functions leaves things to be desired.

Yea.

> What did you run into exactly?

A generic plan was used on a partitioned table. Normally the function
could be inlined so that wasn't noticeable, but in one case it
wasn't... It's confusing if all invocations of the same function are
reasonably fast, but one, with the numerically same values passed down,
isn't.

Andres

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2015-07-10 14:04:46 Re: [PATCH] Generalized JSON output functions
Previous Message Shulgin, Oleksandr 2015-07-10 13:57:59 Re: [PATCH] Generalized JSON output functions