From: Gerardo Herzig <gherzig@fmed.uba.ar>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: using of select (myfunction()).* is so slow
Date: Fri, 04 Feb 2011 07:51:13 -0300
Message-ID: <1296816673.1100.2.camel@inca.fmed.uba.ar> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gherzig@fmed.uba.ar, pavel.stehule@gmail.com
Subject: Re: using of select (myfunction()).* is so slow
In-Reply-To: <1296816673.1100.2.camel@inca.fmed.uba.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox