using of select (myfunction()).* is so slow

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: pgsql-sql(at)postgresql(dot)org
Subject: using of select (myfunction()).* is so slow
Date: 2011-02-03 18:40:02
Message-ID: 1296758402.30254.6.camel@inca.fmed.uba.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all, im using a function of my own in a subquery, and when wonderig
about the slowliness of this one, y relalize that:

test=# SELECT (_xxfunction(854,'711H',11,false)).* ;
(4 filas)
--Result DELETED
Duración: 1069,465 ms

glyms=# SELECT * from _xxfunction(854,'711H',11,false) ;
(4 filas)
Duración: 228,699 ms

For privacy reasons, i just deleted the result and the function name,
but the resulst are obviously exactly the same, and the ().* form (which
i needed) is taking so much more...there is a reason why? A workaround?

Thanks!

Gerardo

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2011-02-03 19:47:31 Re: using of select (myfunction()).* is so slow
Previous Message Tom Lane 2011-02-03 16:31:46 Re: Transaction-specific global variable