【PostgreSQL里pg_filenode.map文件的意义】

于 2024-03-19 09:25:43 发布
阅读量590 收藏 8
点赞数 9
分类专栏： PostgreSQL 文章标签： postgresql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_47308871/article/details/136829880
版权

一、关于pg_filenode.map

通常情况下，PostgreSQL中每张表在磁盘上都有与之相关的文件，而这些文件的名字便是relfilenode，我们可以通过pg_class的relfilenode字段去查询。

postgres=# select relname,oid,relfilenode,reltablespace from pg_class where relname in ('pg_database','pg_class','pg_type','pg_namespace','pg_attribute','tab_1');

   relname    |  oid  | relfilenode | reltablespace
--------------+-------+-------------+---------------
 pg_type      |  1247 |           0 |             0
 tab_1        | 33125 |       33136 |             0
 pg_namespace |  2615 |        2615 |             0
 pg_database  |  1262 |           0 |          1664
 pg_attribute |  1249 |           0 |             0
 pg_class     |  1259 |           0 |             0
(6 rows)

对于一张普通表，其relfilenode和oid默认是一样的。系统表有的也是。但当我们对该表进行了例如vacuum full、truncate之类的操作，表重建后，那么relfilenode便会发生变化。

pg_class视图里，通过reltablespace字段我们也可以发现分为两类系统表：一类是pg_type、pg_attribute、pg_proc和pg_class，它们是非共享的表，在内核中我们称为Nail表。而另一类则是reltablespace为1664的，即在pg_global表空间里的共享表。

有一部分特殊的表我们会发现其对应的表relfilenode为0，官方文档的解释为：0表示这是一个“映射”关系，其磁盘文件名取决于底层状态。对于这种访问十分频繁的系统表，不希望每次都是从一些其它的系统表去查询，这样性能便会非常低，它们便是通过pg_filenode.map文件去进行管理的。pg_filenode.map在base的目录每个库的目录以及global目录下均有一个。

postgres@ubuntu-linux-22-04-desktop:~/data-16$ ll global/pg_filenode.map
-rw------- 1 postgres postgres 524 Dec 26 01:06 global/pg_filenode.map
postgres@ubuntu-linux-22-04-desktop:~/data-16$ ll base/*/pg_filenode.map
-rw------- 1 postgres postgres 524 Dec 26 01:06 base/1/pg_filenode.map
-rw------- 1 postgres postgres 524 Jan 17 10:40 base/13008/pg_filenode.map
-rw------- 1 postgres postgres 524 Dec 26 01:06 base/16385/pg_filenode.map
-rw------- 1 postgres postgres 524 Dec 26 01:06 base/4/pg_filenode.map

在global和base对应数据库的pg_filenode.map文件中，将这些系统表的oid与relfileno做映射，文件的大小为512，刚好是一个OS disk sector的大小。这个文件最多存放62条系统catalog表的记录

二、base目录对应数据库目录下的pg_filenode.map（非共享）

postgres@ubuntu-linux-22-04-desktop:~/data-16/base/13008$ pg_filedump -m pg_filenode.map

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility
*
* File: pg_filenode.map
* Options used: -m
*******************************************************************
Magic Number: 0x592717 (CORRECT)
Num Mappings: 17
Detailed Mappings list:
OID: 1259       Filenode: 41317
OID: 1249       Filenode: 1249
OID: 1255       Filenode: 1255
OID: 1247       Filenode: 1247
OID: 2836       Filenode: 2836
OID: 2837       Filenode: 2837
OID: 4171       Filenode: 4171
OID: 4172       Filenode: 4172
OID: 2690       Filenode: 2690
OID: 2691       Filenode: 2691
OID: 2703       Filenode: 2703
OID: 2704       Filenode: 2704
OID: 2658       Filenode: 2658
OID: 2659       Filenode: 2659
OID: 2662       Filenode: 41320
OID: 2663       Filenode: 41321
OID: 3455       Filenode: 41322

可以结合脚本过滤，原本数据库里系统表和oid的对应关系如下,其中pg_toast_1255和pg_toast_1247分别为pg_proc和pg_type的toast表

//拼接所有的oid，并加上相关字段，便于后边查询对象。
postgres@ubuntu-linux-22-04-desktop:~/data-16/base/13008$ pg_filedump -m pg_filenode.map | grep OID| awk '{print "or oid="$2}'|awk 'ORS=NR%17?" ":"\n"{print}'

or oid=1259 or oid=1249 or oid=1255 or oid=1247 or oid=2836 or oid=2837 or oid=4171 or oid=4172 or oid=2690 or oid=2691 or oid=2703 or oid=2704 or oid=2658 or oid=2659 or oid=2662 or oid=2663 or oid=3455

postgres=#  select relname,oid,relfilenode,reltablespace from pg_class where oid=1259 or oid=1249 or oid=1255 or oid=1247 or oid=2836 or oid=2837 or oid=4171 or oid=4172 or oid=2690 or oid=2691 or oid=2703 or oid=2704 or oid=2658 or oid=2659 or oid=2662 or oid=2663 or oid=3455;
              relname              | oid  | relfilenode | reltablespace
-----------------------------------+------+-------------+---------------
 pg_type                           | 1247 |           0 |             0
 pg_toast_1255                     | 2836 |           0 |             0
 pg_toast_1247                     | 4171 |           0 |             0
 pg_toast_1255_index               | 2837 |           0 |             0
 pg_toast_1247_index               | 4172 |           0 |             0
 pg_proc_oid_index                 | 2690 |           0 |             0
 pg_proc_proname_args_nsp_index    | 2691 |           0 |             0
 pg_type_oid_index                 | 2703 |           0 |             0
 pg_type_typname_nsp_index         | 2704 |           0 |             0
 pg_attribute_relid_attnam_index   | 2658 |           0 |             0
 pg_attribute_relid_attnum_index   | 2659 |           0 |             0
 pg_class_oid_index                | 2662 |           0 |             0
 pg_class_relname_nsp_index        | 2663 |           0 |             0
 pg_class_tblspc_relfilenode_index | 3455 |           0 |             0
 pg_attribute                      | 1249 |           0 |             0
 pg_proc                           | 1255 |           0 |             0
 pg_class                          | 1259 |           0 |             0
(17 rows)

也可以使用如下脚本，查看存储的对象和oid及Filenode

 pg_filedump -m pg_filenode.map | grep OID | grep 1247 | awk '{print "Relname:pg_type " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2836 | awk '{print "Relname:pg_toast_1255 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4171 | awk '{print "Relname:pg_toast_1247 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2837 | awk '{print "Relname:pg_toast_1255_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4172 | awk '{print "Relname:pg_toast_1247_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2690 | awk '{print "Relname:pg_proc_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2691 | awk '{print "Relname:pg_proc_proname_args_nsp_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2703 | awk '{print "Relname:pg_type_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2704 | awk '{print "Relname:pg_type_typname_nsp_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2658 | awk '{print "Relname:pg_attribute_relid_attnam_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2659 | awk '{print "Relname:pg_attribute_relid_attnum_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2662 | awk '{print "Relname:pg_class_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2663 | awk '{print "Relname:pg_class_relname_nsp_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 3455 | awk '{print "Relname:pg_class_tblspc_relfilenode_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1249 | awk '{print "Relname:pg_attribute " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1255 | awk '{print "Relname:pg_proc " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1259 | awk '{print "Relname:pg_class " $1" "$2" "$3" "$4}'

结果如下

Relname:pg_type OID: 1247 Filenode: 1247
Relname:pg_toast_1255 OID: 2836 Filenode: 2836
Relname:pg_toast_1247 OID: 4171 Filenode: 4171
Relname:pg_toast_1255_index OID: 2837 Filenode: 2837
Relname:pg_toast_1247_index OID: 4172 Filenode: 4172
Relname:pg_proc_oid_index OID: 2690 Filenode: 2690
Relname:pg_proc_proname_args_nsp_index OID: 2691 Filenode: 2691
Relname:pg_type_oid_index OID: 2703 Filenode: 2703
Relname:pg_type_typname_nsp_index OID: 2704 Filenode: 2704
Relname:pg_attribute_relid_attnam_index OID: 2658 Filenode: 2658
Relname:pg_attribute_relid_attnum_index OID: 2659 Filenode: 2659
Relname:pg_class_oid_index OID: 2662 Filenode: 41320
Relname:pg_class_relname_nsp_index OID: 2663 Filenode: 41321
Relname:pg_class_tblspc_relfilenode_index OID: 3455 Filenode: 41322
Relname:pg_attribute OID: 1249 Filenode: 1249
Relname:pg_proc OID: 1255 Filenode: 1255
Relname:pg_class OID: 1259 Filenode: 41317

三、global目录下的pg_filenode.map（共享）

//拼接所有的oid，并加上相关字段，便于后边查询对象。
postgres@ubuntu-linux-22-04-desktop:~/data-16/global$  pg_filedump -m pg_filenode.map | grep OID| awk '{print "or oid="$2}'|awk 'ORS=NR%17?" ":"\n"{print}'
or oid=1262 or oid=2964 or oid=1213 or oid=1260 or oid=1261 or oid=1214 or oid=2396 or oid=6000 or oid=3592 or oid=6243 or oid=6100 or oid=4177 or oid=4178 or oid=2966 or oid=2967 or oid=4185 or oid=4186
or oid=4175 or oid=4176 or oid=2846 or oid=2847 or oid=4181 or oid=4182 or oid=4060 or oid=4061 or oid=6244 or oid=6245 or oid=4183 or oid=4184 or oid=2671 or oid=2672 or oid=2965 or oid=2697 or oid=2698
or oid=2676 or oid=2677 or oid=6303 or oid=2694 or oid=2695 or oid=6302 or oid=1232 or oid=1233 or oid=2397 or oid=6001 or oid=6002 or oid=3593 or oid=6246 or oid=6247 or oid=6114 or oid=6115

取对应包含的系统表。

postgres=#  select relname,oid,relfilenode,reltablespace from pg_class where oid=1262 or oid=2964 or oid=1213 or oid=1260 or oid=1261 or oid=1214 or oid=2396 or oid=6000 or oid=3592 or oid=6243 or oid=6100 or oid=4177 or oid=4178 or oid=2966 or oid=2967 or oid=4185 or oid=4186 or oid=4175 or oid=4176 or oid=2846 or oid=2847 or oid=4181 or oid=4182 or oid=4060 or oid=4061 or oid=6244 or oid=6245 or oid=4183 or oid=4184 or oid=2671 or oid=2672 or oid=2965 or oid=2697 or oid=2698 or oid=2676 or oid=2677 or oid=6303 or oid=2694 or oid=2695 or oid=6302 or oid=1232 or oid=1233 or oid=2397 or oid=6001 or oid=6002 or oid=3593 or oid=6246 or oid=6247 or oid=6114 or oid=6115;
                 relname                 | oid  | relfilenode | reltablespace
-----------------------------------------+------+-------------+---------------
 pg_toast_1262_index                     | 4178 |           0 |          1664
 pg_toast_2964_index                     | 2967 |           0 |          1664
 pg_toast_1213_index                     | 4186 |           0 |          1664
 pg_toast_1260_index                     | 4176 |           0 |          1664
 pg_toast_2396_index                     | 2847 |           0 |          1664
 pg_toast_6000_index                     | 4182 |           0 |          1664
 pg_toast_3592_index                     | 4061 |           0 |          1664
 pg_toast_6243_index                     | 6245 |           0 |          1664
 pg_toast_6100_index                     | 4184 |           0 |          1664
 pg_database_datname_index               | 2671 |           0 |          1664
 pg_database_oid_index                   | 2672 |           0 |          1664
 pg_db_role_setting_databaseid_rol_index | 2965 |           0 |          1664
 pg_tablespace_oid_index                 | 2697 |           0 |          1664
 pg_tablespace_spcname_index             | 2698 |           0 |          1664
 pg_authid_rolname_index                 | 2676 |           0 |          1664
 pg_authid_oid_index                     | 2677 |           0 |          1664
 pg_auth_members_oid_index               | 6303 |           0 |          1664
 pg_auth_members_role_member_index       | 2694 |           0 |          1664
 pg_auth_members_member_role_index       | 2695 |           0 |          1664
 pg_auth_members_grantor_index           | 6302 |           0 |          1664
 pg_shdepend_depender_index              | 1232 |           0 |          1664
 pg_shdepend_reference_index             | 1233 |           0 |          1664
 pg_shdescription_o_c_index              | 2397 |           0 |          1664
 pg_replication_origin_roiident_index    | 6001 |           0 |          1664
 pg_replication_origin_roname_index      | 6002 |           0 |          1664
 pg_shseclabel_object_index              | 3593 |           0 |          1664
 pg_parameter_acl_parname_index          | 6246 |           0 |          1664
 pg_parameter_acl_oid_index              | 6247 |           0 |          1664
 pg_subscription_oid_index               | 6114 |           0 |          1664
 pg_subscription_subname_index           | 6115 |           0 |          1664
 pg_authid                               | 1260 |           0 |          1664
 pg_toast_6243                           | 6244 |           0 |          1664
 pg_toast_6100                           | 4183 |           0 |          1664
 pg_toast_1262                           | 4177 |           0 |          1664
 pg_toast_2964                           | 2966 |           0 |          1664
 pg_toast_1213                           | 4185 |           0 |          1664
 pg_toast_1260                           | 4175 |           0 |          1664
 pg_toast_2396                           | 2846 |           0 |          1664
 pg_toast_6000                           | 4181 |           0 |          1664
 pg_toast_3592                           | 4060 |           0 |          1664
 pg_database                             | 1262 |           0 |          1664
 pg_db_role_setting                      | 2964 |           0 |          1664
 pg_tablespace                           | 1213 |           0 |          1664
 pg_auth_members                         | 1261 |           0 |          1664
 pg_shdepend                             | 1214 |           0 |          1664
 pg_shdescription                        | 2396 |           0 |          1664
 pg_replication_origin                   | 6000 |           0 |          1664
 pg_shseclabel                           | 3592 |           0 |          1664
 pg_parameter_acl                        | 6243 |           0 |          1664
 pg_subscription                         | 6100 |           0 |          1664
(50 rows)

也可以使用如下脚本

 pg_filedump -m pg_filenode.map | grep OID | grep 4178| awk '{print "Relname:pg_toast_1262_index  " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2967| awk '{print "Relname:pg_toast_2964_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4186| awk '{print "Relname:pg_toast_1213_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4176| awk '{print "Relname:pg_toast_1260_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2847| awk '{print "Relname:pg_toast_2396_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4182| awk '{print "Relname:pg_toast_6000_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4061| awk '{print "Relname:pg_toast_3592_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6245| awk '{print "Relname:pg_toast_6243_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4184| awk '{print "Relname:pg_toast_6100_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2671| awk '{print "Relname:pg_database_datname_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2672| awk '{print "Relname:pg_database_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2965| awk '{print "Relname:pg_db_role_setting_databaseid_rol_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2697| awk '{print "Relname:pg_tablespace_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2698| awk '{print "Relname:pg_tablespace_spcname_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2676| awk '{print "Relname:pg_authid_rolname_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2677| awk '{print "Relname:pg_authid_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6303| awk '{print "Relname:pg_auth_members_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2694| awk '{print "Relname:pg_auth_members_role_member_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2695| awk '{print "Relname:pg_auth_members_member_role_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6302| awk '{print "Relname:pg_auth_members_grantor_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1232| awk '{print "Relname:pg_shdepend_depender_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1233| awk '{print "Relname:pg_shdepend_reference_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2397| awk '{print "Relname:pg_shdescription_o_c_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6001| awk '{print "Relname:pg_replication_origin_roiident_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6002| awk '{print "Relname:pg_replication_origin_roname_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 3593| awk '{print "Relname:pg_shseclabel_object_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6246| awk '{print "Relname:pg_parameter_acl_parname_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6247| awk '{print "Relname:pg_parameter_acl_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6114| awk '{print "Relname:pg_subscription_oid_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6115| awk '{print "Relname:pg_subscription_subname_index " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1260| awk '{print "Relname:pg_authid " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6244| awk '{print "Relname:pg_toast_6243 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4183| awk '{print "Relname:pg_toast_6100 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4177| awk '{print "Relname:pg_toast_1262 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2966| awk '{print "Relname:pg_toast_2964 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4185| awk '{print "Relname:pg_toast_1213 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4175| awk '{print "Relname:pg_toast_1260 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2846| awk '{print "Relname:pg_toast_2396 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4181| awk '{print "Relname:pg_toast_6000 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 4060| awk '{print "Relname:pg_toast_3592 " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1262| awk '{print "Relname:pg_database " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2964| awk '{print "Relname:pg_db_role_setting " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1213| awk '{print "Relname:pg_tablespace " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1261| awk '{print "Relname:pg_auth_members " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 1214| awk '{print "Relname:pg_shdepend " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 2396| awk '{print "Relname:pg_shdescription " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6000| awk '{print "Relname:pg_replication_origin " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 3592| awk '{print "Relname:pg_shseclabel " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6243| awk '{print "Relname:pg_parameter_acl " $1" "$2" "$3" "$4}'
 pg_filedump -m pg_filenode.map | grep OID | grep 6100| awk '{print "Relname:pg_subscription " $1" "$2" "$3" "$4}'

结果如下：

Relname:pg_toast_1262_index  OID: 4178 Filenode: 4178
Relname:pg_toast_2964_index OID: 2967 Filenode: 2967
Relname:pg_toast_1213_index OID: 4186 Filenode: 4186
Relname:pg_toast_1260_index OID: 4176 Filenode: 4176
Relname:pg_toast_2396_index OID: 2847 Filenode: 2847
Relname:pg_toast_6000_index OID: 4182 Filenode: 4182
Relname:pg_toast_3592_index OID: 4061 Filenode: 4061
Relname:pg_toast_6243_index OID: 6245 Filenode: 6245
Relname:pg_toast_6100_index OID: 4184 Filenode: 4184
Relname:pg_database_datname_index OID: 2671 Filenode: 2671
Relname:pg_database_oid_index OID: 2672 Filenode: 2672
Relname:pg_db_role_setting_databaseid_rol_index OID: 2965 Filenode: 2965
Relname:pg_tablespace_oid_index OID: 2697 Filenode: 2697
Relname:pg_tablespace_spcname_index OID: 2698 Filenode: 2698
Relname:pg_authid_rolname_index OID: 2676 Filenode: 2676
Relname:pg_authid_oid_index OID: 2677 Filenode: 2677
Relname:pg_auth_members_oid_index OID: 6303 Filenode: 6303
Relname:pg_auth_members_role_member_index OID: 2694 Filenode: 2694
Relname:pg_auth_members_member_role_index OID: 2695 Filenode: 2695
Relname:pg_auth_members_grantor_index OID: 6302 Filenode: 6302
Relname:pg_shdepend_depender_index OID: 1232 Filenode: 1232
Relname:pg_shdepend_reference_index OID: 1233 Filenode: 1233
Relname:pg_shdescription_o_c_index OID: 2397 Filenode: 2397
Relname:pg_replication_origin_roiident_index OID: 6001 Filenode: 6001
Relname:pg_replication_origin_roname_index OID: 6002 Filenode: 6002
Relname:pg_shseclabel_object_index OID: 3593 Filenode: 3593
Relname:pg_parameter_acl_parname_index OID: 6246 Filenode: 6246
Relname:pg_parameter_acl_oid_index OID: 6247 Filenode: 6247
Relname:pg_subscription_oid_index OID: 6114 Filenode: 6114
Relname:pg_subscription_subname_index OID: 6115 Filenode: 6115
Relname:pg_authid OID: 1260 Filenode: 1260
Relname:pg_toast_6243 OID: 6244 Filenode: 6244
Relname:pg_toast_6100 OID: 4183 Filenode: 4183
Relname:pg_toast_1262 OID: 4177 Filenode: 4177
Relname:pg_toast_2964 OID: 2966 Filenode: 2966
Relname:pg_toast_1213 OID: 4185 Filenode: 4185
Relname:pg_toast_1260 OID: 4175 Filenode: 4175
Relname:pg_toast_2396 OID: 2846 Filenode: 2846
Relname:pg_toast_6000 OID: 4181 Filenode: 4181
Relname:pg_toast_3592 OID: 4060 Filenode: 4060
Relname:pg_database OID: 1262 Filenode: 1262
Relname:pg_db_role_setting OID: 2964 Filenode: 2964
Relname:pg_tablespace OID: 1213 Filenode: 1213
Relname:pg_auth_members OID: 1261 Filenode: 1261
Relname:pg_shdepend OID: 1214 Filenode: 1214
Relname:pg_shdescription OID: 2396 Filenode: 2396
Relname:pg_replication_origin OID: 6000 Filenode: 6000
Relname:pg_shseclabel OID: 3592 Filenode: 3592
Relname:pg_parameter_acl OID: 6243 Filenode: 6243
Relname:pg_subscription OID: 6100 Filenode: 6100
小怪兽ysl
关注
  • 9
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
【0260】pg_filenode.map文件分析（内含map文件读取、解析demo）
专注【PostgreSQL源码学习&研究】
02-19 422
map文件是关键数据：我们没有从丢失或损坏中恢复的自动方法。我们使用CRC来检测损坏。为了最小化更新失败的风险， map文件应该保持在不超过一个标准大小的磁盘扇区(即512字节（bytes）)，并且我们使用就地覆盖而不是玩重命名游戏。下面的结构布局被设计为恰好占用512字节，这可能会使文件系统更新更有效率。数组中的条目没有特定的顺序。我们可以通过坚持OID顺序来加快搜索速度，但考虑到映射集的预期大小，这真的不值得麻烦。
PostgreSQL误删pg_filenode.map怎么办
Focus on PostgreSQL
01-18 1147
今天在网上看到有人问误删pg_filenode.map该如何恢复或者重建，解决这个问题前我们先来了解下pg_filenode.map文件。 对于PostgreSQL中的每张表在磁盘上都有与之相关的文件，而这些文件的名字便是relfilenode，我们可以通过pg_class的relfilenode字段去查询。 但是有一部分特殊的表我们会发现其对应的该字段为0，官方文档的解释为：0表示这是一个“映射”关系，其磁盘文件名取决于低层状态。那么哪些表的relfilenode字段会是0呢？这些relfilenode为
postgresql中根据oid和filenode去找表的物理文件的位置
Silence Ray的博客
03-20 3454
1.新建一张表 postgres=# create table a(a int); CREATE TABLE postgres=# select oid,relfilenode from pg_class where relname='a'; oid | relfilenode -------+------------- 17107 | 17107 (1 row) 我们会发现
postgresql 表文件介绍
一个追逐梦想的码农
04-10 1282
postgres表文件,oid,relfilenode
postgreSQL 之 oid与relfilenode的理解
HighGO
04-03 3746
OID 对象标识符类型Object Identifier Types ，内部使用，并作为系统表的主键； 可以在用户定义的表中使用，默认oid不会添加到 用户自己创建的表里，除非指定 WITH OIDS 或者 default_with_oids 打开，oid是给内部表做标识用的，但不推荐使用； 因为oid本身大小固定的，万一 行数超过了oid 的最大限制数（4 byte int），那就无法插入...
postgresql-database_rev6.json
03-31
postgresql-database_rev6.json
edb_pgagent_pg12.exe
08-30
PostgreSQL数据的定时任务工具pgAgent Windows平台的安装包。一般情况下，你安装了pg之后，在菜单目录下都会有一个 Application Stack Builder ，打开它找到pgAgent去下载安装即可，如果没有那就从这里下载，或者...
PostgreSQL_DBMS_for_Windows_922_136133.exe
08-08
支持ArcGIS10.2版本的PostgreSQL_DBMS_for_windows_922，ESRI官方原版资源。
PostgreSQL分区插件pg_pathman1.5.11的RPM格式安装包
08-05
PostgreSQL12/PostgreSQL11/PostgreSQL10分区插件pg_pathman1.5.11的RPM格式安装包，文件中包含了3个文件： pg_pathman10-1.5.11-1.rhel7.x86_64.rpm pg_pathman11-1.5.11-1.rhel7.x86_64.rpm pg_pathman12-1.5.11-1...
postgresql之pg_dump命令详解 - wling_89的专栏 - 博客频道 - CSDN_NET.mht
05-13
PG导入导出命令详解
PostgreSQL中Oid和Relfilenode的映射
Baiyi_destroyer的博客
09-23 353
这个博客主要阐述了在PostgreSQL中表的oid和relfilenode映射的两种不通表现形式，你只要记住使用永远会得到正确的结果，从pg_class系统表中查询则可能会得到错误的结果。
postgresql 编码_一文看懂PostgreSQL数据目录结构
weixin_39860732的博客
12-21 343
概述我们一般解压PG后可以看到有很多个目录，那么这些目录都代表什么意思呢?1、根目录介绍data├── base # use to store database file(SELECT oid, datname FROM pg_database;)├── global # under global, all the filenode is hard-code(select oid,relname,...
7.PostgreSQL物理结构-逻辑结构相关概念
weixin_43346403的博客
03-24 342
postgresql
PostgreSQL 物理文件映射解析
05-10 393
我们知道，在PG中，每个relation，也就是表，都有好几个fork对应。存放主表数据的为“MAIN” fork；管理空余空间的为“FSM” fork；存放可视化视图的为“visibility” fork。 ...
mysql 物理文件映射_PostgreSQL 物理文件映射解析
weixin_42651281的博客
02-01 115
我们知道，在PG中，每个relation，也就是表，都有好几个fork对应。存放主表数据的为“MAIN” fork；管理空余空间的为“FSM” fork；存放可视化视图的为“visibility” fork。那么PG又是如何将每个表的fork管理起来，并跟pg_class中的relfileno对应起来的呢？这可以分为两类：一类是常规表；一类是系统表。1.常规表假设我有一张表叫”tab_mvcc_t...
Postgresql数据库体系结构-存储结构
weixin_33835103的博客
04-11 626
PostgreSQL数据库体系结构-存储结构 存储结构 聚簇逻辑结构聚簇物理结构 聚簇数据库数据文件表空间数据文件内部结构tuple的读写方法 1、数据库聚簇逻辑结构（Logical Structure of Database Cluster） database cluster--数据库聚簇，是一组数据库的集合，而不是多个数据库服务器 d...
Postgresql关于Vacuum的作用和操作方法，Vacuum full锁表并生成新的relfilenode
很多时候犯错都是在不知情的情况下发生的
04-16 9634
官方文档 http://postgres.cn/docs/11/sql-vacuum.html http://postgres.cn/docs/11/routine-vacuuming.html 个人实验得出的一些总结 1、官方文档说vacuum full会释放磁盘空间，标准VACUUM(即不带FULL)不会，标准VACUUM也能把该表文件空间交还给操作系统的情况：表尾部有空页就能释放这个空页的空间，页包含页头部和行数据，也就是说如果每行数据都是死元组，那么整个这个页就是空闲的，实验场景，当我们insert
PostgreSQL 的pg_hba.conf在哪？
最新发布
05-23
pg_hba.conf 是 PostgreSQL 的客户端认证配置文件，用于配置客户端连接 PostgreSQL 数据库时的认证方式。这个文件通常位于 PostgreSQL 的数据目录中，具体路径视操作系统和 PostgreSQL 版本而定。常见的位置包括： ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

小怪兽ysl

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值