Re: Stored Procedure Speed

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

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-04-25 18:05:32 Re: Schema as versioning strategy
Previous Message araza 2007-04-25 18:02:39 Where to find kind code for STATISTIC_KIND GEOMETRY?