Message-ID: <53E0D48F.9060107@aklaver.com>
Date: Tue, 05 Aug 2014 05:56:47 -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>,
 "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: function call
References: 
 <CABnqL31EW-f2jKd=SMi+gwesgYJwwxizwx1q3B+nQxT7hqD2VA@mail.gmail.com>
In-Reply-To: 
 <CABnqL31EW-f2jKd=SMi+gwesgYJwwxizwx1q3B+nQxT7hqD2VA@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/05/2014 04:28 AM, Marcin Krawczyk wrote:
> Hi list,
>
> I have a SET returning function (defined as RETURNS TABLE), it takes 2
> parameters and always returns one row with 3 columns. Now when I run it
> from pgAdmin it takes around 5 seconds but when I run it from the
> application its around 3 minutes (same parameters of course). It shows
> up in the postgres' status server and odbc log right away so I believe
> the applications has nothing to do with it. Where should I start looking ?

More information would be helpful.

For now I am guessing in your application you are using ODBC to connect 
to the server, correct? This is an additional step not found in the 
pgAdmin route which may be a clue.

More questions:

1) What does the function do?

2) Where are the database and pgAdmin and the application in relation to 
each other? In other words are they on the same machine or are they 
going across a network?

3) What is the application?

>
> I'm running postgres 9.1
>
>
> 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