这一部分包含PostgreSQL开发者可能用到的各类信息。

目录

51. PostgreSQL内部概述 : 51.1. 一个查询的路径

[51.2. 连接如何建立](connect-estab.md)

[51.3. 分析器阶段](parser-stage.md)

[51.4. PostgreSQL规则系统](rule-system.md)

[51.5. 规划器/优化器](planner-optimizer.md)

[51.6. 执行器](executor.md)

52. 系统目录 : 52.1. 概述

[52.2. `pg_aggregate`](catalog-pg-aggregate.md)

[52.3. `pg_am`](catalog-pg-am.md)

[52.4. `pg_amop`](catalog-pg-amop.md)

[52.5. `pg_amproc`](catalog-pg-amproc.md)

[52.6. `pg_attrdef`](catalog-pg-attrdef.md)

[52.7. `pg_attribute`](catalog-pg-attribute.md)

[52.8. `pg_authid`](catalog-pg-authid.md)

[52.9. `pg_auth_members`](catalog-pg-auth-members.md)

[52.10. `pg_cast`](catalog-pg-cast.md)

[52.11. `pg_class`](catalog-pg-class.md)

[52.12. `pg_collation`](catalog-pg-collation.md)

[52.13. `pg_constraint`](catalog-pg-constraint.md)

[52.14. `pg_conversion`](catalog-pg-conversion.md)

[52.15. `pg_database`](catalog-pg-database.md)

[52.16. `pg_db_role_setting`](catalog-pg-db-role-setting.md)

[52.17. `pg_default_acl`](catalog-pg-default-acl.md)

[52.18. `pg_depend`](catalog-pg-depend.md)

[52.19. `pg_description`](catalog-pg-description.md)

[52.20. `pg_enum`](catalog-pg-enum.md)

[52.21. `pg_event_trigger`](catalog-pg-event-trigger.md)

[52.22. `pg_extension`](catalog-pg-extension.md)

[52.23. `pg_foreign_data_wrapper`](catalog-pg-foreign-data-wrapper.md)

[52.24. `pg_foreign_server`](catalog-pg-foreign-server.md)

[52.25. `pg_foreign_table`](catalog-pg-foreign-table.md)

[52.26. `pg_index`](catalog-pg-index.md)

[52.27. `pg_inherits`](catalog-pg-inherits.md)

[52.28. `pg_init_privs`](catalog-pg-init-privs.md)

[52.29. `pg_language`](catalog-pg-language.md)

[52.30. `pg_largeobject`](catalog-pg-largeobject.md)

[52.31. `pg_largeobject_metadata`](catalog-pg-largeobject-metadata.md)

[52.32. `pg_namespace`](catalog-pg-namespace.md)

[52.33. `pg_opclass`](catalog-pg-opclass.md)

[52.34. `pg_operator`](catalog-pg-operator.md)

[52.35. `pg_opfamily`](catalog-pg-opfamily.md)

[52.36. `pg_partitioned_table`](catalog-pg-partitioned-table.md)

[52.37. `pg_pltemplate`](catalog-pg-pltemplate.md)

[52.38. `pg_policy`](catalog-pg-policy.md)

[52.39. `pg_proc`](catalog-pg-proc.md)

[52.40. `pg_publication`](catalog-pg-publication.md)

[52.41. `pg_publication_rel`](catalog-pg-publication-rel.md)

[52.42. `pg_range`](catalog-pg-range.md)

[52.43. `pg_replication_origin`](catalog-pg-replication-origin.md)

[52.44. `pg_rewrite`](catalog-pg-rewrite.md)

[52.45. `pg_seclabel`](catalog-pg-seclabel.md)

[52.46. `pg_sequence`](catalog-pg-sequence.md)

[52.47. `pg_shdepend`](catalog-pg-shdepend.md)

[52.48. `pg_shdescription`](catalog-pg-shdescription.md)

[52.49. `pg_shseclabel`](catalog-pg-shseclabel.md)

[52.50. `pg_statistic`](catalog-pg-statistic.md)

[52.51. `pg_statistic_ext`](catalog-pg-statistic-ext.md)

[52.52. `pg_subscription`](catalog-pg-subscription.md)

[52.53. `pg_subscription_rel`](catalog-pg-subscription-rel.md)

[52.54. `pg_tablespace`](catalog-pg-tablespace.md)

[52.55. `pg_transform`](catalog-pg-transform.md)

[52.56. `pg_trigger`](catalog-pg-trigger.md)

[52.57. `pg_ts_config`](catalog-pg-ts-config.md)

[52.58. `pg_ts_config_map`](catalog-pg-ts-config-map.md)

[52.59. `pg_ts_dict`](catalog-pg-ts-dict.md)

[52.60. `pg_ts_parser`](catalog-pg-ts-parser.md)

[52.61. `pg_ts_template`](catalog-pg-ts-template.md)

[52.62. `pg_type`](catalog-pg-type.md)

[52.63. `pg_user_mapping`](catalog-pg-user-mapping.md)

[52.64. 系统视图](views-overview.md)

[52.65. `pg_available_extensions`](view-pg-available-extensions.md)

[52.66. `pg_available_extension_versions`](view-pg-available-extension-versions.md)

[52.67. `pg_config`](view-pg-config.md)

[52.68. `pg_cursors`](view-pg-cursors.md)

[52.69. `pg_file_settings`](view-pg-file-settings.md)

[52.70. `pg_group`](view-pg-group.md)

[52.71. `pg_hba_file_rules`](view-pg-hba-file-rules.md)

[52.72. `pg_indexes`](view-pg-indexes.md)

[52.73. `pg_locks`](view-pg-locks.md)

[52.74. `pg_matviews`](view-pg-matviews.md)

[52.75. `pg_policies`](view-pg-policies.md)

[52.76. `pg_prepared_statements`](view-pg-prepared-statements.md)

[52.77. `pg_prepared_xacts`](view-pg-prepared-xacts.md)

[52.78. `pg_publication_tables`](view-pg-publication-tables.md)

[52.79. `pg_replication_origin_status`](view-pg-replication-origin-status.md)

[52.80. `pg_replication_slots`](view-pg-replication-slots.md)

[52.81. `pg_roles`](view-pg-roles.md)

[52.82. `pg_rules`](view-pg-rules.md)

[52.83. `pg_seclabels`](view-pg-seclabels.md)

[52.84. `pg_sequences`](view-pg-sequences.md)

[52.85. `pg_settings`](view-pg-settings.md)

[52.86. `pg_shadow`](view-pg-shadow.md)

[52.87. `pg_stats`](view-pg-stats.md)

[52.88. `pg_tables`](view-pg-tables.md)

[52.89. `pg_timezone_abbrevs`](view-pg-timezone-abbrevs.md)

[52.90. `pg_timezone_names`](view-pg-timezone-names.md)

[52.91. `pg_user`](view-pg-user.md)

[52.92. `pg_user_mappings`](view-pg-user-mappings.md)

[52.93. `pg_views`](view-pg-views.md)

53. 前端/后端协议 : 53.1. 概述

[53.2. 消息流](protocol-flow.md)

[53.3. SASL认证](sasl-authentication.md)

[53.4. 流复制协议](protocol-replication.md)

[53.5. 逻辑流复制协议](protocol-logical-replication.md)

[53.6. 消息数据类型](protocol-message-types.md)

[53.7. 消息格式](protocol-message-formats.md)

[53.8. 错误和通知消息域](protocol-error-fields.md)

[53.9. 逻辑复制消息格式](protocol-logicalrep-message-formats.md)

[53.10. 自协议2.0以来的变化总结](protocol-changes.md)

54. PostgreSQL编码习惯 : 54.1. 格式化

[54.2. 在服务器中报告错误](error-message-reporting.md)

[54.3. 错误消息风格指导](error-style-guide.md)

[54.4. 其他编码习惯](source-conventions.md)

55. 本国语言支持 : 55.1. 给翻译者

[55.2. 给编程者](nls-programmer.md)

56. 编写一个过程语言处理器

57. 编写一个外部数据包装器 : 57.1. 外部数据包装器函数

[57.2. 外部数据包装器回调例程](fdw-callbacks.md)

[57.3. 外部数据包装器助手函数](fdw-helpers.md)

[57.4. 外部数据包装器查询规划](fdw-planning.md)

[57.5. 外部数据包装器中的行锁定](fdw-row-locking.md)

58. 编写一种表采样方法 : 58.1. 采样方法支持函数

59. 编写一个自定义扫描提供者 : 59.1. 创建自定义扫描路径

[59.2. 创建自定义扫描计划](custom-scan-plan.md)

[59.3. 执行自定义扫描](custom-scan-execution.md)

60. 遗传查询优化器 : 60.1. 将查询处理看成是一个复杂的优化问题

[60.2. 遗传算法](geqo-intro2.md)

[60.3. PostgreSQL 中的遗传查询优化（GEQO）](geqo-pg-intro.md)

[60.4. 进一步阅读](geqo-biblio.md)

61. 索引访问方法接口定义 : 61.1. 索引的基本 API 结构

[61.2. 索引访问方法函数](index-functions.md)

[61.3. 索引扫描](index-scanning.md)

[61.4. 索引锁定考虑](index-locking.md)

[61.5. 索引唯一性检查](index-unique-checks.md)

[61.6. 索引开销估计函数](index-cost-estimation.md)

62. 通用WAL 记录

63. B-树索引 : 63.1. 简介

[63.2. B-树操作符类的行为](btree-behavior.md)

[63.3. B-树支持函数](btree-support-funcs.md)

[63.4. 实现](btree-implementation.md)

64. GiST 索引 : 64.1. 简介

[64.2. 内建操作符类](gist-builtin-opclasses.md)

[64.3. 可扩展性](gist-extensibility.md)

[64.4. 实现](gist-implementation.md)

[64.5. 示例](gist-examples.md)

65. SP-GiST索引 : 65.1. 简介

[65.2. 内建操作符类](spgist-builtin-opclasses.md)

[65.3. 可扩展性](spgist-extensibility.md)

[65.4. 实现](spgist-implementation.md)

[65.5. 例子](spgist-examples.md)

66. GIN 索引 : 66.1. 简介

[66.2. 内建操作符类](gin-builtin-opclasses.md)

[66.3. 可扩展性](gin-extensibility.md)

[66.4. 实现](gin-implementation.md)

[66.5. GIN 提示和技巧](gin-tips.md)

[66.6. 限制](gin-limit.md)

[66.7. 例子](gin-examples.md)

67. BRIN 索引 : 67.1. 简介

[67.2. 内建操作符类](brin-builtin-opclasses.md)

[67.3. 可扩展性](brin-extensibility.md)

68. 数据库物理存储 : 68.1. 数据库文件布局

[68.2. TOAST](storage-toast.md)

[68.3. 空闲空间映射](storage-fsm.md)

[68.4. 可见性映射](storage-vm.md)

[68.5. 初始化分支](storage-init.md)

[68.6. 数据库页面布局](storage-page-layout.md)

69. 系统目录声明和初始内容 : 69.1. 系统目录声明规则

[69.2. 系统目录初始数据](system-catalog-initial-data.md)

[69.3. BKI文件格式](bki-format.md)

[69.4. BKI命令](bki-commands.md)

[69.5. 自举BKI文件的结构](bki-structure.md)

[69.6. BKI例子](bki-example.md)

70. 规划器如何使用统计信息 : 70.1. 行估计例子

[70.2. 多变量统计例子](multivariate-statistics-examples.md)

[70.3. 规划器统计和安全](planner-stats-security.md)