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["CRC（循环冗余校验）原理"]
n1["Algorithms"]
n2["Database"]
n3["Bitcask 存储模型（日志结构哈希表）"]
n4["KV 数据库对比"]
n5["KV 数据库"]
n6["PostgreSQL 活跃会话诊断（Active Sessions）"]
n7["PostgreSQL 磁盘占用查看（Table Size / Datafile）"]
n8["PostgreSQL"]
n9["PostgreSQL 内存占用查看（Memory / Buffers / Connections）"]
n10["PostgreSQL 查看慢查询（Slow Query）"]
n11["PostgreSQL WAL 与 LSN"]
n12["Knowledge"]
n13["Cloud"]
n14["对象存储基本用法（Bucket / Object / 常用操作）"]
n15["Object Storage"]
n16["挂载 Bucket 为本地文件系统（FUSE Mount）"]
n17["对象存储签名 URL（Signed URL）原理与实战"]
n18["对象存储供应商对比（S3 / R2 / OSS / Supabase / MinIO）"]
n19["Infrastructure"]
n20["Prototypes"]
n21["Protomaps 自建底图研究"]
n22["MapLibre 集成 Protomaps"]
n1 --> n0
n2 --> n5
n2 --> n8
n4 --> n3
n5 --> n3
n5 --> n4
n8 --> n6
n8 --> n7
n8 --> n9
n8 --> n10
n8 --> n11
n9 --> n6
n9 --> n7
n10 --> n6
n12 --> n1
n12 --> n2
n12 --> n19
n13 --> n15
n14 --> n17
n14 --> n18
n14 --> n20
n15 --> n14
n15 --> n16
n15 --> n17
n15 --> n18
n16 --> n14
n16 --> n17
n16 --> n18
n17 --> n20
n18 --> n14
n18 --> n17
n18 --> n20
n19 --> n13
n20 --> n3
n20 --> n14
n20 --> n16
n20 --> n17
n20 --> n18
n20 --> n21
n21 --> n22
n22 --> n20
click n0 "../../algorithms/crc/" "CRC（循环冗余校验）原理"
click n1 "../../algorithms/" "Algorithms"
click n2 "../" "Database"
click n3 "../kv/bitcask/" "Bitcask 存储模型（日志结构哈希表）"
click n4 "../kv/comparison/" "KV 数据库对比"
click n5 "../kv/" "KV 数据库"
click n6 "active-sessions/" "PostgreSQL 活跃会话诊断（Active Sessions）"
click n7 "disk-usage/" "PostgreSQL 磁盘占用查看（Table Size / Datafile）"
click n8 "./" "PostgreSQL"
click n9 "memory-usage/" "PostgreSQL 内存占用查看（Memory / Buffers / Connections）"
click n10 "slow-queries/" "PostgreSQL 查看慢查询（Slow Query）"
click n11 "wal-lsn/" "PostgreSQL WAL 与 LSN"
click n12 "../../" "Knowledge"
click n13 "../../infrastructure/cloud/" "Cloud"
click n14 "../../infrastructure/cloud/object-storage/basic-usage/" "对象存储基本用法（Bucket / Object / 常用操作）"
click n15 "../../infrastructure/cloud/object-storage/" "Object Storage"
click n16 "../../infrastructure/cloud/object-storage/mount-bucket/" "挂载 Bucket 为本地文件系统（FUSE Mount）"
click n17 "../../infrastructure/cloud/object-storage/signed-url/" "对象存储签名 URL（Signed URL）原理与实战"
click n18 "../../infrastructure/cloud/object-storage/vendors-comparison/" "对象存储供应商对比（S3 / R2 / OSS / Supabase / MinIO）"
click n19 "../../infrastructure/" "Infrastructure"
click n20 "../../../prototypes/" "Prototypes"
click n21 "../../../research/topics/protomaps/" "Protomaps 自建底图研究"
click n22 "../../../research/topics/protomaps/maplibre/" "MapLibre 集成 Protomaps"