Re: Assigning fixed OIDs to system catalogs and indexes

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Assigning fixed OIDs to system catalogs and indexes
Date: 2005-04-13 02:10:43
Message-ID: 20050413021043.GF12223@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Apr 13, 2005 at 09:54:28AM +0800, Christopher Kings-Lynne wrote:
> >So some changing-oid operations like vacuum full, reindex, etc will not
> >affect these system catalogs?
>
> Is it possible to cluster system tables?

No. And then, some catalogs are only allowed to be reindexed in place.
(I think only shared catalogs.)

VACUUM FULL does not change the Oid, does it?

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Siempre hay que alimentar a los dioses, aunque la tierra esté seca" (Orual)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-04-13 02:13:25 Re: Assigning fixed OIDs to system catalogs and indexes
Previous Message Christopher Kings-Lynne 2005-04-13 02:10:32 Re: ISO-8859-1 encoding not enforced?