Home > mailing lists

Efficiency of CREATE TABLE AS - Mailing list pgsql-novice

From	Brian Herlihy
Subject	Efficiency of CREATE TABLE AS
Date	May 9, 2007 05:34:15
Msg-id	799123.3654.qm@web52303.mail.re2.yahoo.com Whole thread Raw
Responses	Re: Efficiency of CREATE TABLE AS
List	pgsql-novice

Tree view

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:

From: "Chamara Gunaratne"
Date: 09 May 2007, 01:38:11
Subject: Re: Disk and shared buffer cache use

From: Tom Lane
Date: 09 May 2007, 05:57:37
Subject: Re: Efficiency of CREATE TABLE AS

Efficiency of CREATE TABLE AS - Mailing list pgsql-novice

Previous

Next