Postgres Pro
Downloads
Home   >   mailing lists

Re: function call - Mailing list pgsql-sql

From Marcin Krawczyk
Subject Re: function call
Date
Msg-id CABnqL30b-cZUJE69QJw0kueiwJ=uBPOLDnbgRWz7hrwo-=Frfw@mail.gmail.com
Whole thread Raw
In response to Re: function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: function call  ("John L. Poole" <jlpoole56@gmail.com>)
Re: function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
Tree view
It's not ODBC, I've just tested with simple C# through the same odbc source and the function takes 4 seconds as well.


regards
mk


2014-08-05 15:01 GMT+02:00 Adrian Klaver <adrian.klaver@aklaver.com>:
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 ?

Just had another thought.

I found in the past that ODBC logging can slow things down considerably.

What happens if you turn off the ODBC logging?




I'm running postgres 9.1


regards
mk


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-sql by date:

Previous
From: Marcin Krawczyk
Date:
Subject: Re: function call
Next
From: "John L. Poole"
Date:
Subject: Re: function call