Re: Object like pg_class.relkind = 's' or 'c' have on-disk file? - Mailing list pgsql-general

From Tom Lane
Subject Re: Object like pg_class.relkind = 's' or 'c' have on-disk file?
Date
Msg-id 20880.1111041333@sss.pgh.pa.us
Whole thread Raw
In response to Re: Object like pg_class.relkind = 's' or 'c' have on-disk file?  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Responses Re: Object like pg_class.relkind = 's' or 'c' have on-disk  (Katsuhiko Okano <k_okano@po.ntts.co.jp>)
List pgsql-general
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> Pg_xactlock is always there as a special relation.

pg_xactlock isn't really a relation.  The way I think about it is that
it's a dummy entry in pg_class that exists to reserve a relation OID
for a specific purpose --- namely, we can lock transaction IDs by
locking what would otherwise be a page of that relation.

There was some talk recently about reorganizing the locktag design
so that transaction lock tags would be clearly distinguishable from
any lock associated with a relation.  If we got that done, there'd
be no need for the pg_xactlock entry at all.

> I am not sure about 'c'.

'c' entries in pg_class are for composite types.  They don't have
any associated disk storage either.

            regards, tom lane

pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: foreign key help
Next
From: Richard Huxton
Date:
Subject: Re: search_path, schemas and functions...