Re: assignment vs SELECT INTO - Mailing list pgsql-performance

From Tom Lane
Subject Re: assignment vs SELECT INTO
Date
Msg-id 25915.1415046245@sss.pgh.pa.us
Whole thread Raw
In response to assignment vs SELECT INTO  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: assignment vs SELECT INTO  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-performance
Andrew Dunstan <andrew@dunslane.net> writes:
>     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 think it's more likely that the second example is treated as a "simple
expression" so it has less overhead than a SELECT.

            regards, tom lane


pgsql-performance by date:

Previous
From: Andrew Dunstan
Date:
Subject: assignment vs SELECT INTO
Next
From: Matheus de Oliveira
Date:
Subject: Re: assignment vs SELECT INTO