Re: Stored Procedures and compiling

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Stored Procedures and compiling
Дата
Msg-id 3240.1047093204@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Stored Procedures and compiling  (Daniel Bruce Lynes <dlynes@shaw.ca>)
Ответы Re: Stored Procedures and compiling  (Daniel Bruce Lynes <dlynes@shaw.ca>)
Список pgsql-performance
Daniel Bruce Lynes <dlynes@shaw.ca> writes:
> I am curious if there is any planned support for full stored procedure
> compiling?  I've seen that PostgreSQL does not compile the SQL code inside
> plpgsql code.  It is merely interpreted when the procedure gets called.  This
> is also documented in the main html documentation.
> What I am wondering specifically is if stored procedure compiling will work
> similar to Oracle's stored procedure compilation in the future?

What exactly do you consider "compiling", and why do you think that
whatever Oracle does (which you didn't bother to explain) is superior
to what plpgsql does?

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Index / Performance issues
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: Slow query performance on large table