On Thu, 2003-09-11 at 08:12, Christopher Browne wrote:
> Something I am feeling a little suspicious of is that I haven't seen,
> in the logs, pg_autovacuum looking at pg_ tables.
>
> I know that if we don't periodically vacuum such system tables as
> pg_class, pg_attribute, pg_statistic, and pg_type, they can get to
> "pretty evil size."
>
> [Rummaging around...] These tables are being added for template1, but
> apparently not for "main" databases. That looks like a bit of a fly
> in the ointment...
I designed it that way. It was my understanding that all of the system
tables pg_class etc... are shared tables, available in all databases,
but actually stored as only one central set of real tables. Hence
vacuuming pg_class from template1 helps every database that accesses
pg_class.
Did I make a design error?
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
