Subject: Re: using of select (myfunction()).* is so slow
From: Gerardo Herzig <gherzig@fmed.uba.ar>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <AANLkTimY=sDSpAmivZyPCZqhwzO+38tBd+rKFT+6cY=9@mail.gmail.com>
References: <1296758402.30254.6.camel@inca.fmed.uba.ar>
	<AANLkTimY=sDSpAmivZyPCZqhwzO+38tBd+rKFT+6cY=9@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Date: Fri, 04 Feb 2011 07:51:13 -0300
Message-ID: <1296816673.1100.2.camel@inca.fmed.uba.ar>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

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@fmed.uba.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@postgresql.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