Re: Stored Procedure Speed

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Scott Schulthess <scott(at)topozone(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Stored Procedure Speed
Date: 2007-04-25 18:06:43
Message-ID: 462F98B3.2040904@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Richard Huxton <dev(at)archonet(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Porell, Chris 2007-04-25 18:22:35 PosegreSQL support
Previous Message Richard Huxton 2007-04-25 18:05:32 Re: Schema as versioning strategy