On Mon, Nov 3, 2014 at 6:00 PM, Andrew Dunstan <and...@dunslane.net> wrote:

>    andrew=# do $x$ declare r abc; begin for i in 1 .. 10000000 loop
>    select 'a','b',i into r.x,r.y,r.z; end loop; end; $x$;
>    DO
>    Time: 63731.434 ms
>    andrew=# do $x$ declare r abc; begin for i in 1 .. 10000000 loop r
>    := ('a','b',i); end loop; end; $x$;
>    DO
>    Time: 18744.151 ms
>
>
> Is it simply because the SELECT is in effect three assignments, so it
> takes nearly 3 times as long?
>


I don't think so, because this take pretty much the same time:

    SELECT ('a','b',i) INTO r;

Regards,
-- 
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nĂ­vel F!
www.dextra.com.br/postgres

Reply via email to