postgres
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChinesePlanetScale Postgres
PlanetScale Postgres
Generic Postgres
通用Postgres相关
| Topic | Reference | Use for |
|---|---|---|
| Schema Design | references/schema-design.md | Tables, primary keys, data types, foreign keys |
| Indexing | references/indexing.md | Index types, composite indexes, performance |
| Index Optimization | references/index-optimization.md | Unused/duplicate index queries, index audit |
| Partitioning | references/partitioning.md | Large tables, time-series, data retention |
| Query Patterns | references/query-patterns.md | SQL anti-patterns, JOINs, pagination, batch queries |
| Optimization Checklist | references/optimization-checklist.md | Pre-optimization audit, cleanup, readiness checks |
| MVCC and VACUUM | references/mvcc-vacuum.md | Dead tuples, long transactions, xid wraparound prevention |
| 主题 | 参考链接 | 适用场景 |
|---|---|---|
| Schema设计 | references/schema-design.md | 表、主键、数据类型、外键 |
| 索引优化 | references/indexing.md | 索引类型、复合索引、性能优化 |
| 索引调优 | references/index-optimization.md | 未使用/重复索引查询、索引审计 |
| 分区 | references/partitioning.md | 大表、时间序列数据、数据留存 |
| 查询模式 | references/query-patterns.md | SQL反模式、JOIN操作、分页、批量查询 |
| 优化检查清单 | references/optimization-checklist.md | 预优化审计、清理、就绪检查 |
| MVCC与VACUUM | references/mvcc-vacuum.md | 死元组、长事务、xid回卷预防 |
Operations and Architecture
运维与架构
| Topic | Reference | Use for |
|---|---|---|
| Process Architecture | references/process-architecture.md | Multi-process model, connection pooling, auxiliary processes |
| Memory Architecture | references/memory-management-ops.md | Shared/private memory layout, OS page cache, OOM prevention |
| MVCC Transactions | references/mvcc-transactions.md | Isolation levels, XID wraparound, serialization errors |
| WAL and Checkpoints | references/wal-operations.md | WAL internals, checkpoint tuning, durability, crash recovery |
| Replication | references/replication.md | Streaming replication, slots, sync commit, failover |
| Storage Layout | references/storage-layout.md | PGDATA structure, TOAST, fillfactor, tablespaces, disk mgmt |
| Monitoring | references/monitoring.md | pg_stat views, logging, pg_stat_statements, host metrics |
| Backup and Recovery | references/backup-recovery.md | pg_dump, pg_basebackup, PITR, WAL archiving, backup tools |
| 主题 | 参考链接 | 适用场景 |
|---|---|---|
| 进程架构 | references/process-architecture.md | 多进程模型、连接池、辅助进程 |
| 内存架构 | references/memory-management-ops.md | 共享/私有内存布局、OS页缓存、OOM预防 |
| MVCC事务 | references/mvcc-transactions.md | 隔离级别、XID回卷、序列化错误 |
| WAL与检查点 | references/wal-operations.md | WAL内部机制、检查点调优、持久性、崩溃恢复 |
| 复制 | references/replication.md | 流复制、复制槽、同步提交、故障转移 |
| 存储布局 | references/storage-layout.md | PGDATA结构、TOAST、fillfactor、表空间、磁盘管理 |
| 监控 | references/monitoring.md | pg_stat视图、日志、pg_stat_statements、主机指标 |
| 备份与恢复 | references/backup-recovery.md | pg_dump、pg_basebackup、PITR、WAL归档、备份工具 |
PlanetScale-Specific
PlanetScale专属内容
| Topic | Reference | Use for |
|---|---|---|
| Connection Pooling | references/ps-connection-pooling.md | PgBouncer, pool sizing, pooled vs direct |
| Extensions | references/ps-extensions.md | Supported extensions, compatibility |
| Connections | references/ps-connections.md | Connection troubleshooting, drivers, SSL |
| Insights | references/ps-insights.md | Slow queries, MCP server, pscale CLI |
| CLI Commands | references/ps-cli-commands.md | pscale CLI reference, branches, deploy requests, auth |
| CLI API Insights | references/ps-cli-api-insights.md | Query insights via |
| 主题 | 参考链接 | 适用场景 |
|---|---|---|
| 连接池 | references/ps-connection-pooling.md | PgBouncer、池大小配置、池化连接vs直连 |
| 扩展 | references/ps-extensions.md | 支持的扩展、兼容性 |
| 连接管理 | references/ps-connections.md | 连接故障排查、驱动、SSL |
| 性能分析 | references/ps-insights.md | 慢查询、MCP服务器、pscale CLI |
| CLI命令 | references/ps-cli-commands.md | pscale CLI参考、分支、部署请求、认证 |
| CLI API分析 | references/ps-cli-api-insights.md | 通过 |