Re: assignment vs SELECT INTO

On Mon, Nov 3, 2014 at 6:00 PM, Andrew Dunstan <andrew(at)dunslane(dot)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