Jacqui Caren-home <jacqui.ca...@ntlworld.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
