Efficiency of CREATE TABLE AS

From: Brian Herlihy <btherl(at)yahoo(dot)com(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: Efficiency of CREATE TABLE AS
Date: 2007-05-09 05:34:10
Message-ID: 799123.3654.qm@web52303.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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.

Thanks,
Brian

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-05-09 05:57:31 Re: Efficiency of CREATE TABLE AS
Previous Message Chamara Gunaratne 2007-05-09 01:38:05 Re: Disk and shared buffer cache use