Re: [GENERAL] create table as select VS create table; insert as select

Jacqui Caren-home writes: > I have inherited an application that populates a number of > temp.y tables using create table ... as select ... > As this process hammers the database, I can only run benchmarks at night so > am asking here if anyone know if > create table ...; then insert into ... as s

Re: [GENERAL] create table as select VS create table; insert as select

Hi, On 29 October 2010 11:46, Jacqui Caren-home wrote: > I have inherited an application that populates a number of > temp.y tables using create table ... as select ... What is the principle of creating this temp.y tables? May be table partitioning is better to implement here - http://www.postgr

[GENERAL] create table as select VS create table; insert as select

I have inherited an application that populates a number of temp.y tables using create table ... as select ... This is taking roughly five to ten minutes to run As this process hammers the database, I can only run benchmarks at night so am asking here if anyone know if create table ...; then ins