agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Marcin Krawczyk <jankes.mk@gmail.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: function call
Date: Tue, 05 Aug 2014 05:56:47 -0700
Message-ID: <53E0D48F.9060107@aklaver.com> (raw)
In-Reply-To: <CABnqL31EW-f2jKd=SMi+gwesgYJwwxizwx1q3B+nQxT7hqD2VA@mail.gmail.com>
References: <CABnqL31EW-f2jKd=SMi+gwesgYJwwxizwx1q3B+nQxT7hqD2VA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

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

view thread (13+ messages)  latest in thread

Message-ID: <53E0D48F.9060107@aklaver.com>
Permalink:  ../53E0D48F.9060107@aklaver.com/
Also on:    postgresql.org/message-id/53E0D48F.9060107@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: <53E0D48F.9060107@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