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
