Re: function call

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: function call
Дата
Msg-id 53E91300.1050005@aklaver.com
обсуждение исходный текст
Ответ на Re: function call  (Marcin Krawczyk <jankes.mk@gmail.com>)
Ответы Re: function call  (Marcin Krawczyk <jankes.mk@gmail.com>)
Список pgsql-sql
Дерево обсуждения 
On 08/11/2014 02:50 AM, Marcin Krawczyk wrote:
> I've managed to determine that there's a trigger dependency tree that
> slows things down. When I DISABLE one of them the function takes under
> 30 seconds, still more than from pgAdmin but much quicker than before.

I am with David. I am not sure you are calling the same function in each 
case.

Are you sure you have not overloaded the function name and a difference 
in search_paths is not causing a different version to be run?

>
> regards
> mk



-- 
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: Igor Neyman
Дата:
Сообщение: Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value'
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value'