Re: assignment vs SELECT INTO

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: assignment vs SELECT INTO
Дата
Msg-id CAJghg4JpvKk4qG3SWZdH3zPk=3U-9Rc_BqYKD=JgLwp8F-LD6g@mail.gmail.com
обсуждение исходный текст
Ответ на assignment vs SELECT INTO  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-performance

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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: assignment vs SELECT INTO
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: assignment vs SELECT INTO