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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Chamara Gunaratne"
Дата:
Сообщение: Re: Disk and shared buffer cache use
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Efficiency of CREATE TABLE AS