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 по дате отправления: