PostgreSQL 百科
按主题查阅 PostgreSQL，追溯每个版本的定义。
查阅 PostgreSQL 的命令、参数与数据库对象，了解它们的含义、用法和版本变化。每个栏目保留对应版本的手册或源码链接。
4735 条来源记录· 30 个专题
查询语言
索引与存储
系统目录
系统目录与视图的字段构成，以及逐版本的结构变化。
索引访问方法
Index capabilities, query patterns, limits and storage options.
表访问方法
Table access methods, tuple organization, MVCC, maintenance and implementation boundaries.
操作符族
Index operator classes and families, strategy operators and support functions.
存储参数
Table and index storage options from each version’s manual.
存储结构
Database files, relation forks, pages, tuples, TOAST, free-space and visibility maps.
OID 类型
OID alias types, input forms, and object lookup behavior.
运行与诊断
配置参数
全部配置参数的作用、默认值演变与调优取舍。
执行计划
Execution plan nodes, source interfaces, strategies, resource behavior and examples.
等待事件
每个等待事件的触发机制、是否异常与排查手段。
锁
Table and row locks, conflicts, and the commands that acquire them.
统计与指标
Individually addressable statistics and progress fields, definitions, units and reset context.
认证方法
Client authentication methods, configuration, requirements and version-specific behavior.
预定义角色
Built-in roles and their version-specific privileges.
客户端与协议
psql 命令
Backslash commands with exact syntax, modifiers, examples and client-version history.
命令行工具
Client and server programs, command options, environment variables and operational examples.
连接参数
libpq connection keywords, environment mappings, defaults and precedence by client version.
协议消息
Frontend/backend message directions, wire fields and same-version protocol definitions.
扩展机制
外部数据包装器
External data adapters, versioned capabilities, transaction behavior and extension evidence.
扩展钩子
Core extension points, signatures, and versioned source definitions.
过程语言
Core procedural languages, handlers, trust boundaries and versioned programming interfaces.
全文检索组件
Text search parsers, dictionaries, templates and configurations with source identities.
排序规则与编码
Server encodings and collation providers with explicit locale and build-dependent boundaries.
逻辑解码插件
Logical decoding output plugins, formats, options and implementation-specific evidence.
版本
从一个问题开始。
查阅 work_mem, pg_class, 40P01, 或探索命令语法 MERGE. 每个条目都链接到所选版本的手册与来源。