function slower than the same code in an sql file

Поиск
Список
Период
Сортировка
От CS DBA
Тема function slower than the same code in an sql file
Дата
Msg-id 4EAA3597.3020202@consistentstate.com
обсуждение исходный текст
Ответы Re: function slower than the same code in an sql file  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: function slower than the same code in an sql file  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-performance
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