agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: Marcin Krawczyk <jankes.mk@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: function call
Date: Mon, 11 Aug 2014 12:01:20 -0700
Message-ID: <53E91300.1050005@aklaver.com> (raw)
In-Reply-To: <CABnqL33m+KqSYqMW=YCHWSt3213CXoaS-8=tbkGuk=JibURd4w@mail.gmail.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (13+ messages) latest in thread
Message-ID: <53E91300.1050005@aklaver.com>
Permalink: ../53E91300.1050005@aklaver.com/
Also on: postgresql.org/message-id/53E91300.1050005@aklaver.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, jankes.mk@gmail.com
Subject: Re: function call
In-Reply-To: <53E91300.1050005@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox