Re: Stored Procedure Speed - Mailing list pgsql-general

From Richard Huxton
Subject Re: Stored Procedure Speed
Date
Msg-id 462F98B3.2040904@archonet.com
Whole thread Raw
In response to Re: Stored Procedure Speed  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Stored Procedure Speed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Richard Huxton <dev@archonet.com> writes:
>> I must say I thought recent versions of PG delayed planning the query
>> until first call though.
>
> No, you're thinking of parameterized queries sent through the FE/BE
> protocol.  Functions still plan without any assumptions about parameter
> values.

Ah, fair enough. I *am* right in thinking that trivial SQL functions
will have their expressions inlined though?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Schema as versioning strategy
Next
From: "Porell, Chris"
Date:
Subject: PosegreSQL support