Re: SQL Functions vs PL/PgSQL
От | Johnny Kristensen |
---|---|
Тема | Re: SQL Functions vs PL/PgSQL |
Дата | |
Msg-id | 005a01c2d409$39f6b960$dc9ac450@johnny обсуждение исходный текст |
Ответ на | SQL Functions vs PL/PgSQL ("Johnny Kristensen" <johnnybo1@mail.tele.dk>) |
Список | pgsql-sql |
Of course what I meant was if postgres stores execution plans for queries in user-defined SQL functions. From the docs Ican see that PL/PgSQL uses the SPI-interface to create and store execution plans for queries for each connection. But I'lluse the PREPARE function like Thomasz Myrta suggested. /Johnny ----- Original Message ----- From: "Josh Berkus" <josh@agliodbs.com> To: "Johnny Kristensen" <johnnybo1@mail.tele.dk>; <pgsql-sql@postgresql.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@postgresql.org)
В списке pgsql-sql по дате отправления: