Re: Another small bug (pg_autovacuum)

"Matthew T. O'Connor" <matthew@zeut.net> writes:
> On Thu, 2003-09-11 at 08:12, Christopher Browne wrote:
>> [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.

You are very badly mistaken.

Only the tables marked "relisshared" in pg_class (currently pg_shadow,
pg_group, pg_database, and their indexes and toast tables) are shared
across a cluster.  The rest have separate copies per-database.
        regards, tom lane