WITHOUT OIDS

Hi all,



We have a function that runs under cron every 5 minutes. It creates a lot of
temp tables.



The Function slows down during the day considerably.  I suspect it is due
the constant creation and dropping of temp tables.  If I vacuum full
pg_attribute and pg_class it fixes the problem.  But unfortunately vacuuming
these table every run is not practical as it takes so much time.



If I were to create the temp tables without oids, does this mean both
pg_attribute and pg_class will not be as affected.



If so, can I specify without oids when creating a temp table as follows?



create temp table test

as

select * from test2



Thanks


Andrew Bartley