From: | "Johnny Kristensen" <johnnybo1(at)mail(dot)tele(dot)dk> |
---|---|
To: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: SQL Functions vs PL/PgSQL |
Date: | 2003-02-14 09:12:39 |
Message-ID: | 005a01c2d409$39f6b960$dc9ac450@johnny |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Of course what I meant was if postgres stores execution plans for queries in user-defined SQL functions. From the docs I can see that PL/PgSQL uses the SPI-interface to create and store execution plans for queries for each connection. But I'll use the PREPARE function like Thomasz Myrta suggested.
/Johnny
----- Original Message -----
From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Johnny Kristensen" <johnnybo1(at)mail(dot)tele(dot)dk>; <pgsql-sql(at)postgresql(dot)org>
Sent: Thursday, February 13, 2003 6:02 PM
Subject: Re: [SQL] SQL Functions vs PL/PgSQL
Johnny,
> Does postgres store execution plan's for user-defined SQL functions as the
> PL/pgSQL interpreter does. And if so - will this only be prepared after an
> initial call to the function? Can't seem to find this information in the
> docs!? Thanks,
Unless you know something I don't, I do not believe that PL/pgSQL stores
execution plans for functions.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Weaver | 2003-02-14 09:29:36 | Re: Passing arrays |
Previous Message | David Durst | 2003-02-14 08:57:59 | Re: Passing arrays |