Efficiency of CREATE TABLE AS - Mailing list pgsql-novice

From Brian Herlihy
Subject Efficiency of CREATE TABLE AS
Date
Msg-id 799123.3654.qm@web52303.mail.re2.yahoo.com
Whole thread Raw
Responses Re: Efficiency of CREATE TABLE AS  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Chamara Gunaratne"
Date:
Subject: Re: Disk and shared buffer cache use
Next
From: Tom Lane
Date:
Subject: Re: Efficiency of CREATE TABLE AS