Re: function call - Mailing list pgsql-sql

Wouldn't this issue be an excellent candidate to create a test example and then log a bug with all the details so others can recreate the issue?  It's very difficult to divine what the problem is unless you can provide a working example that demonstrates it.

John

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