Re: function call - Mailing list pgsql-sql

From Adrian Klaver
Subject Re: function call
Date
Msg-id 53E91300.1050005@aklaver.com
Whole thread Raw
In response to Re: function call  (Marcin Krawczyk <jankes.mk@gmail.com>)
Responses Re: function call
List 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 by date:

Previous
From: Igor Neyman
Date:
Subject: Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value'
Next
From: Pavel Stehule
Date:
Subject: Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value'