对PostgreSQL中 pg_各表的RelationId的认识

读取普通的table或者系统表，都会调用heap_open函数：

/* ----------------
 *        heap_open - open a heap relation by relation OID
 *
 *        This is essentially relation_open plus check that the relation
 *        is not an index nor a composite type.  (The caller should also
 *        check that it's not a view or foreign table before assuming it has
 *        storage.)
 * ----------------
 */
Relation
heap_open(Oid relationId, LOCKMODE lockmode)
{
    //fprintf(stderr,"++++++++++++++++++++ In heap_open start by process %d....relationId is:%d\n",
　　　　　　getpid(),relationId);
    Relation    r;

    r = relation_open(relationId, lockmode);

    if (r->rd_rel->relkind == RELKIND_INDEX)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("\"%s\" is an index",
                        RelationGetRelationName(r))));
    else if (r->rd_rel->relkind == RELKIND_COMPOSITE_TYPE)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("\"%s\" is a composite type",
                        RelationGetRelationName(r))));

    //fprintf(stderr,"++++++++++++++++++++ In heap_open end by process %d\n\n",getpid());

    return r;
}

对于普通表而言，RelationId就是在base目录下的某个子目录里面的文件名。

但是对于系统表而言，则不同。
比如 pg_tablespace 的RelationId为 1213（这已经写死在PostgreSQL源代码中），
但是其对应的文件的名称为 12587（对应global/12587文件）。

经过一番测试，发现其对应关系如下：

 

pg_default_acl	826
pg_pltemplate	1136
pg_tablespace	1213
pg_shdepend	1214
pg_type	1247
pg_attribute	1249
pg_proc	1255
pg_class	1259
pg_authid	1260
pg_auth_members	1261
pg_database	1262
pg_foreign_server	1417
pg_user_mapping	1418
pg_foreign_data_wrapper	2328
pg_shdescription	2396
pg_aggregate	2600
pg_am	2601
pg_amop	2602
pg_ampro	2603
pg_attrdef	2604
pg_cast	2605
pg_constraint	2606
pg_conversion	2607
pg_depend	2608
pg_description	2609
pg_index	2610
pg_inherits	2611
pg_language	2612
pg_largeobject	2613
pg_namespace	2615
pg_opclass	2616
pg_operator	2617
pg_rewrite	2618
pg_stastic	2619
pg_trigger	2620
pg_opfamily	2753
pg_db_role_setting	2964
pg_largeobject_metadata	2995
pg_extension	3079
pg_foreign_table	3118
pg_collation	3456
pg_enum	3501
pg_seclabel	3596
pg_ts_dict	3600
pg_ts_parser	3601
pg_ts_config	3602
pg_ts_config_map	3603
pg_ts_template	3764

 然后，我还可以进一步，观察 ，把上述表格补充完整：

/* ----------------
 *        relation_open - open any relation by relation OID
 *
 *        If lockmode is not "NoLock", the specified kind of lock is
 *        obtained on the relation.  (Generally, NoLock should only be
 *        used if the caller knows it has some appropriate lock on the
 *        relation already.)
 *
 *        An error is raised if the relation does not exist.
 *
 *        NB: a "relation" is anything with a pg_class entry.  The caller is
 *        expected to check whether the relkind is something it can handle.
 * ----------------
 */
Relation
relation_open(Oid relationId, LOCKMODE lockmode)
{

    fprintf(stderr,"___________________ In relation_open start by process %d\n",getpid());

    Relation    r;

    Assert(lockmode >= NoLock && lockmode < MAX_LOCKMODES);

    /* Get the lock before trying to open the relcache entry */
    if (lockmode != NoLock)
        LockRelationOid(relationId, lockmode);

    /* The relcache does all the real work... */
    r = RelationIdGetRelation(relationId);

    fprintf(stderr,"In relation_open ,the relNode is:%d....\n\n",r->rd_node.relNode);

    if (!RelationIsValid(r))
        elog(ERROR, "could not open relation with OID %u", relationId);

    /* Make note that we've accessed a temporary relation */
    if (RelationUsesLocalBuffers(r))
        MyXactAccessedTempRel = true;

    pgstat_initstats(r);

    fprintf(stderr,"___________________ In relation_open end by process %d\n",getpid());

    return r;
}

加入了调试代码后，我可以看到，pg_tablespace 的 RelationId是 1213，而它的对应文件名是 12587。

下面，补充完整：

system table name	RelationId	FileName
pg_default_acl	826	12642
pg_pltemplate	1136	12591
pg_tablespace	1213	12587
pg_shdepend	1214	12598
pg_type	1247	12442
pg_attribute	1249	12446
pg_proc	1255	12458
pg_class	1259	12465
pg_authid	1260	12450
pg_auth_members	1261	12594
pg_database	1262	12692
pg_foreign_server	1417	12635
pg_user_mapping	1418	12454
pg_foreign_data_wrapper	2328	12631
pg_shdescription	2396	12602
pg_aggregate	2600	12525
pg_am	2601	12505
pg_amop	2602	12509
pg_ampro	2603	12514
pg_attrdef	2604	12469
pg_cast	2605	12549
pg_constraint	2606	12476
pg_conversion	2607	12562
pg_depend	2608	12567
pg_description	2609	12543
pg_index	2610	12489
pg_inherits	2611	12485
pg_language	2612	12518
pg_largeobject	2613	12571
pg_namespace	2615	12558
pg_opclass	2616	12501
pg_operator	2617	12493
pg_rewrite	2618	12528
pg_stastic	2619	12436
pg_trigger	2620	12535
pg_opfamily	2753	12497
pg_db_role_setting	2964	12581
pg_largeobject_metadata	2995	12522
pg_extension	3079	12627
pg_foreign_table	3118	12639
pg_collation	3456	12652
pg_enum	3501	12553
pg_seclabel	3596	12646
pg_ts_dict	3600	12615
pg_ts_parser	3601	12619
pg_ts_config	3602	12608
pg_ts_config_map	3603	12612
pg_ts_template	3764	12623

 如果进一步查看，还可以发现：

只有如下几个系统表的对应文件位于 global目录，其余的系统表的对应文件则是base目录下的每个子目录中都有（一个子目录对应一个数据库）：

system table name	RelationId	FileName
pg_pltemplate	1136	12591
pg_tablespace	1213	12587
pg_shdepend	1214	12598
pg_authid	1260	12450
pg_auth_members	1261	12594
pg_database	1262	12692
pg_shdescription	2396	12602
pg_db_role_setting	2964	12581