Re: WITHOUT OIDS

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(at)samurai(dot)com> || PGP Key ID: DB3C29FC