From: | Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: using of select (myfunction()).* is so slow |
Date: | 2011-02-04 10:51:13 |
Message-ID: | 1296816673.1100.2.camel@inca.fmed.uba.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
El jue, 03-02-2011 a las 20:47 +0100, Pavel Stehule escribió:
> Hello
>
> If you use a record expansion over function's result, then function is
> called once for record's field.
>
> so don't do it on slow functions.
>
> Regards
>
> Pavel
>
>
> 2011/2/3 Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>:
> > 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
> >
> >
> > --
> > Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-sql
> >
>
Mmmmm ok Thanks...So there is no workaround/alternative to this?
Gerardo
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2011-02-04 11:17:44 | Re: using of select (myfunction()).* is so slow |
Previous Message | Viktor Bojović | 2011-02-04 08:33:21 | Re: How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1? |