Re: LANGUAGE sql functions don't use the custom plan logic - Mailing list pgsql-hackers

From Andres Freund
Subject Re: LANGUAGE sql functions don't use the custom plan logic
Date
Msg-id 20150710135902.GK26521@alap3.anarazel.de
Whole thread Raw
In response to Re: LANGUAGE sql functions don't use the custom plan logic  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: [PATCH] Generalized JSON output functions
Next
From: Pavel Stehule
Date:
Subject: Re: [PATCH] Generalized JSON output functions