PostgreSQL
PostgreSQL 日常运维与内部机制知识体系 —— 面向「遇到问题能查、能看懂 PG 在干什么」的实战沉淀：会话与性能诊断、WAL / LSN 机制、复制与备份等。 知识点按问题/主题独立成文，长期演进。
Docs
| Docs | Description |
|---|---|
| 活跃会话诊断（Active Sessions） | 查看当前活跃 Session、定位 CPU 高占用与慢查询、终止会话 |
| 查看慢查询（Slow Query） | 慢查询定位：日志记录（log_min_duration_statement / auto_explain）与实时统计（pg_stat_activity / pg_stat_statements） |
| 磁盘占用查看（Table Size / Datafile） | 数据库/表/索引/TOAST 空间占用、数据文件位置与膨胀排查 |
| 内存占用查看（Memory / Buffers / Connections） | 内存分层、查看与配置修改：shared_buffers / work_mem / 临时表与临时文件 / 连接数 / ALTER SYSTEM 持久化 |
| WAL 与 LSN | WAL 机制、LSN 概念与常用查询：当前位置、文件、复制进度 |
Backlinks (1)
flowchart LR
n0["Database"]
n1["Bitcask 存储模型（日志结构哈希表）"]
n2["KV 数据库对比"]
n3["KV 数据库"]
n4["PostgreSQL 活跃会话诊断（Active Sessions）"]
n5["PostgreSQL 磁盘占用查看（Table Size / Datafile）"]
n6["PostgreSQL"]
n7["PostgreSQL 内存占用查看（Memory / Buffers / Connections）"]
n8["PostgreSQL 查看慢查询（Slow Query）"]
n9["PostgreSQL WAL 与 LSN"]
n10["Knowledge"]
n11["Cloud"]
n12["对象存储基本用法（Bucket / Object / 常用操作）"]
n13["Object Storage"]
n14["挂载 Bucket 为本地文件系统（FUSE Mount）"]
n15["对象存储签名 URL（Signed URL）原理与实战"]
n16["对象存储供应商对比（S3 / R2 / OSS / Supabase / MinIO）"]
n17["Infrastructure"]
n18["Prototypes"]
n19["Protomaps 自建底图研究"]
n20["MapLibre 集成 Protomaps"]
n0 --> n3
n0 --> n6
n2 --> n1
n3 --> n1
n3 --> n2
n6 --> n4
n6 --> n5
n6 --> n7
n6 --> n8
n6 --> n9
n7 --> n4
n7 --> n5
n8 --> n4
n10 --> n0
n10 --> n17
n11 --> n13
n12 --> n15
n12 --> n16
n12 --> n18
n13 --> n12
n13 --> n14
n13 --> n15
n13 --> n16
n14 --> n12
n14 --> n15
n14 --> n16
n15 --> n18
n16 --> n12
n16 --> n15
n16 --> n18
n17 --> n11
n18 --> n1
n18 --> n12
n18 --> n14
n18 --> n15
n18 --> n16
n18 --> n19
n19 --> n20
n20 --> n18
click n0 "../" "Database"
click n1 "../kv/bitcask/" "Bitcask 存储模型（日志结构哈希表）"
click n2 "../kv/comparison/" "KV 数据库对比"
click n3 "../kv/" "KV 数据库"
click n4 "active-sessions/" "PostgreSQL 活跃会话诊断（Active Sessions）"
click n5 "disk-usage/" "PostgreSQL 磁盘占用查看（Table Size / Datafile）"
click n6 "./" "PostgreSQL"
click n7 "memory-usage/" "PostgreSQL 内存占用查看（Memory / Buffers / Connections）"
click n8 "slow-queries/" "PostgreSQL 查看慢查询（Slow Query）"
click n9 "wal-lsn/" "PostgreSQL WAL 与 LSN"
click n10 "../../" "Knowledge"
click n11 "../../infrastructure/cloud/" "Cloud"
click n12 "../../infrastructure/cloud/object-storage/basic-usage/" "对象存储基本用法（Bucket / Object / 常用操作）"
click n13 "../../infrastructure/cloud/object-storage/" "Object Storage"
click n14 "../../infrastructure/cloud/object-storage/mount-bucket/" "挂载 Bucket 为本地文件系统（FUSE Mount）"
click n15 "../../infrastructure/cloud/object-storage/signed-url/" "对象存储签名 URL（Signed URL）原理与实战"
click n16 "../../infrastructure/cloud/object-storage/vendors-comparison/" "对象存储供应商对比（S3 / R2 / OSS / Supabase / MinIO）"
click n17 "../../infrastructure/" "Infrastructure"
click n18 "../../../prototypes/" "Prototypes"
click n19 "../../../research/topics/protomaps/" "Protomaps 自建底图研究"
click n20 "../../../research/topics/protomaps/maplibre/" "MapLibre 集成 Protomaps"