function slower than the same code in an sql file

Поиск
Список
Период
Сортировка
Hi All ;

I have code that drops a table, re-create's it (based on a long set of
joins) and then re-creates the indexes.

It runs via psql in about 10 seconds.  I took the code and simply
wrapped it into a plpgsql function and the function version takes almost
60 seconds to run.

I always thought that functions should run faster than psql... am I wrong?

Thanks in advance

--
---------------------------------------------
Kevin Kempter       -       Constent State
A PostgreSQL Professional Services Company
           www.consistentstate.com
---------------------------------------------


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: PostgreSQL 9.0.4 blocking in lseek?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: function slower than the same code in an sql file