Re: WITHOUT OIDS - Mailing list pgsql-general

From Neil Conway
Subject Re: WITHOUT OIDS
Date
Msg-id 1046241625.433.60.camel@tokyo
Whole thread Raw
In response to WITHOUT OIDS  ("Andrew Bartley" <abartley@evolvosystems.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: 7.4?
Next
From: Tom Lane
Date:
Subject: Re: 7.4?