On 11/03/2014 03:24 PM, Tom Lane wrote:
Andrew Dunstan writes:
andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 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 .. 1000 loop
On Mon, Nov 3, 2014 at 6:00 PM, Andrew Dunstan wrote:
>andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 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 .. 1000 loop r
>:= (
Andrew Dunstan writes:
> andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 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 .. 1000 loop r
> := ('a','b',i); end loop; end;
I found out today that direct assignment to a composite type is (at
least in my test) about 70% faster than setting it via SELECT INTO. That
seems like an enormous difference in speed, which I haven't really been
able to account for.
Test case:
andrew=# \d abc
Table "public.abc
