On Tue, 2003-02-25 at 19:59, Andrew Bartley wrote:
> 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.
Does a regular VACUUM accomplish the same result?
> But unfortunately vacuuming these table every run is not practical as
> it takes so much time.
Can you elaborate? VACUUMing *just* the pg_attribute and pg_class tables
takes an excessive amount of time? (You're aware you can VACUUM specific
tables, as well as entire databases, right?)
> If I were to create the temp tables without oids, does this mean both
> pg_attribute and pg_class will not be as affected.
AFAIK, it wouldn't affect either significantly.
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC