Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 25 Apr 2007 19:06:43 +0100
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
- Follow-Ups:
- Re: Stored Procedure Speed
- From: Tom Lane
- Re: Stored Procedure Speed
- References:
- Stored Procedure Speed
- From: Scott Schulthess
- Re: Stored Procedure Speed
- From: Richard Huxton
- Re: Stored Procedure Speed
- From: Tom Lane
- Stored Procedure Speed
- Prev by Date: Re: Schema as versioning strategy
- Next by Date: PosegreSQL support
- Previous by thread: Re: Stored Procedure Speed
- Next by thread: Re: Stored Procedure Speed
- Indexes: