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