Function call costs for SQL and PLPgSQL

Поиск
Список
Период
Сортировка
От Vincenzo Romano
Тема Function call costs for SQL and PLPgSQL
Дата
Msg-id 200706221622.07438.vincenzo.romano@gmail.com
обсуждение исходный текст
Ответы Re: Function call costs for SQL and PLPgSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all.
I need to create a huge SQL script to load 20+ M rows in a DB.
I've been force to wrap the inserts into PG functions.
I can write them in either SQl or PLPgSQL but don't know
whether this can make a big difference as far as time of
overall execution is concerned.

Somewhere else I've been told that SQL function bodies get "inlined"
during execution. Is thus correct to consider SQL functions "faster"
that the conterpart written in PLPgSQL?

Thanks.

--
Vincenzo Romano
--
Maybe Computer will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1988]

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: How to install Postgresql on MS Vista?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: How to install Postgresql on MS Vista?