Message-ID: <53E91300.1050005@aklaver.com>
Date: Mon, 11 Aug 2014 12:01:20 -0700
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: Marcin Krawczyk <jankes.mk@gmail.com>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: function call
References: 
 <CABnqL31EW-f2jKd=SMi+gwesgYJwwxizwx1q3B+nQxT7hqD2VA@mail.gmail.com>
 <53E0D58E.9040502@aklaver.com>
 <CABnqL30b-cZUJE69QJw0kueiwJ=uBPOLDnbgRWz7hrwo-=Frfw@mail.gmail.com>
 <53E23483.4030906@aklaver.com>
 <CABnqL33m+KqSYqMW=YCHWSt3213CXoaS-8=tbkGuk=JibURd4w@mail.gmail.com>
In-Reply-To: 
 <CABnqL33m+KqSYqMW=YCHWSt3213CXoaS-8=tbkGuk=JibURd4w@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql