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 into the new table? I am concerned about the case where there may be many gigabytes of data being copied between these two tables. And my precise concern is that the data may be stored temporarily before being placed in the new table, slowing things down.
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2007-05-09 05:57:31|
|Subject: Re: Efficiency of CREATE TABLE AS |
|Previous:||From: Chamara Gunaratne||Date: 2007-05-09 01:38:05|
|Subject: Re: Disk and shared buffer cache use|