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