Postgres Pro
Downloads
Home   >   mailing lists

function call - Mailing list pgsql-sql

From Marcin Krawczyk
Subject function call
Date
Msg-id CABnqL31EW-f2jKd=SMi+gwesgYJwwxizwx1q3B+nQxT7hqD2VA@mail.gmail.com
Whole thread Raw
Responses Re: function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
Tree view
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 ?

I'm running postgres 9.1 


regards
mk

pgsql-sql by date:

Previous
From: DerekW
Date:
Subject: Re: PostgreSQL add id column that increments based on data
Next
From: Adrian Klaver
Date:
Subject: Re: function call