Efficiency of CREATE TABLE AS

Поиск
Список
Период
Сортировка
От Brian Herlihy
Тема Efficiency of CREATE TABLE AS
Дата
Msg-id 799123.3654.qm@web52303.mail.re2.yahoo.com
обсуждение
Ответы Re: Efficiency of CREATE TABLE AS
Список pgsql-novice
Hi,

If I do the following

CREATE TABLE foo AS SELECT * FROM bar

and a sequential scan is chosen as the plan (in particular, no ordering required), will the rows be written directly
intothe new table?  I am concerned about the case where there may be many gigabytes of data being copied between these
twotables.  And my precise concern is that the data may be stored temporarily before being placed in the new table,
slowingthings down. 

Thanks,
Brian



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