VII. 内部
这部分包含可以用于PostgreSQL开发人员的分类信息。
- Table of Contents
- 44. PostgreSQL内部概览
- 44.1. 查询路径
- 44.2. How Connections are Established连接是如何建立起来的
- 44.3. The Parser Stage分析器阶段
- 44.4. The PostgreSQL Rule SystemPostgreSQL 规则系统
- 44.5. Planner/Optimizer规划器/优化器
- 44.6. Executor执行器
- 45. 系统表
- 45.1. 概述
- 45.2. pg_aggregate
- 45.3. pg_am
- 45.4. pg_amop
- 45.5. pg_amproc
- 45.6. pg_attrdef
- 45.7. pg_attribute
- 45.8. pg_authid
- 45.9. pg_auth_members
- 45.10. pg_cast
- 45.11. pg_class
- 45.12. pg_constraint
- 45.13. pg_conversion
- 45.14. pg_database
- 45.15. pg_db_role_setting
- 45.16. pg_default_acl
- 45.17. pg_depend
- 45.18. pg_description
- 45.19. pg_enum
- 45.20. pg_foreign_data_wrapper
- 45.21. pg_foreign_server
- 45.22. pg_index
- 45.23. pg_inherits
- 45.24. pg_language
- 45.25. pg_largeobject
- 45.26. pg_largeobject_metadata
- 45.27. pg_namespace
- 45.28. pg_opclass
- 45.29. pg_operator
- 45.30. pg_opfamily
- 45.31. pg_pltemplate
- 45.32. pg_proc
- 45.33. pg_rewrite
- 45.34. pg_shdepend
- 45.35. pg_shdescription
- 45.36. pg_statistic
- 45.37. pg_tablespace
- 45.38. pg_trigger
- 45.39. pg_ts_config
- 45.40. pg_ts_config_map
- 45.41. pg_ts_dict
- 45.42. pg_ts_parser
- 45.43. pg_ts_template
- 45.44. pg_type
- 45.45. pg_user_mapping
- 45.46. 系统视图
- 45.47. pg_cursors
- 45.48. pg_group
- 45.49. pg_indexes
- 45.50. pg_locks
- 45.51. pg_prepared_statements
- 45.52. pg_prepared_xacts
- 45.53. pg_roles
- 45.54. pg_rules
- 45.55. pg_settings
- 45.56. pg_shadow
- 45.57. pg_stats
- 45.58. pg_tables
- 45.59. pg_timezone_abbrevs
- 45.60. pg_timezone_names
- 45.61. pg_user
- 45.62. pg_user_mappings
- 45.63. pg_views
- 46. Frontend/Backend Protocol
- 46.1. Overview
- 46.2. Message Flow
- 46.3. Streaming Replication Protocol
- 46.4. Message Data Types
- 46.5. Message Formats
- 46.6. Error and Notice Message Fields
- 46.7. Summary of Changes since Protocol 2.0
- 47. PostgreSQL Coding Conventions
- 47.1. Formatting
- 47.2. Reporting Errors Within the Server
- 47.3. Error Message Style Guide
- 48. Native Language Support
- 48.1. For the Translator
- 48.2. For the Programmer
- 49. Writing A Procedural Language Handler
- 50. Genetic Query Optimizer
- 50.1. Query Handling as a Complex Optimization Problem
- 50.2. Genetic Algorithms
- 50.3. Genetic Query Optimization (GEQO) in PostgreSQL
- 50.4. Further Reading
- 51. 索引访问方法接口定义
- 51.1. 索引的系统表记录
- 51.2. 索引访问方法函数
- 51.3. 索引扫描
- 51.4. 索引锁的考量
- 51.5. 索引唯一性检查
- 51.6. 索引开销估计函数
- 52. GiST Indexes
- 52.1. Introduction
- 52.2. Extensibility
- 52.3. Implementation
- 52.4. Examples
- 52.5. Crash Recovery
- 53. GIN Indexes
- 53.1. Introduction
- 53.2. Extensibility
- 53.3. Implementation
- 53.4. GIN tips and tricks
- 53.5. Limitations
- 53.6. Examples
- 54. 数据库物理存储
- 54.1. 数据库文件布局
- 54.2. TOAST
- 54.3. 自由空间映射
- 54.4. 可见映射
- 54.5. 数据库分页文件
- 55.
BKI后端接口
- 55.1.
BKI 文件格式
- 55.2.
BKI命令
- 55.3. 系统初始化的BKI文件的结构
- 55.4. 例子
- 56. 规划器如何使用统计信息
- 56.1. 行预期的例子