Jacqui Caren-home <jacqui.caren@xxxxxxxxxxxx> 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 select... ; would be faster. No, it'd likely be slower --- possibly quite a bit slower. When you say "temp-y", do you mean these are in fact TEMP tables? If not, can you make them be so? That would help. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
