postgres-tuning

Optimizes PostgreSQL 17/18+ performance across I/O, query execution, indexing, and maintenance. Covers the native AIO subsystem introduced in PostgreSQL 18 for throughput gains on modern storage, forensic query plan analysis with EXPLAIN BUFFERS (auto-included in PG18), B-tree skip scans for composite indexes, native UUIDv7 generation, and autovacuum tuning for high-churn tables.

When to use: Diagnosing slow queries, configuring async I/O, tuning sharedbuffers and workmem, optimizing indexes for write-heavy workloads, managing table bloat, pgvector HNSW tuning.

When NOT to use: Schema design (use a data modeling tool), application-level caching strategy, database selection decisions, ORM query generation.

PostgreSQL 17/18+ 效能調整與最佳化。涵蓋非同步 I/O 配置、查詢計畫取證、索引策略、autovacuum 調整、向量搜尋最佳化、連線池、宣告式分割區和實用查詢模式。在診斷慢查詢、配置非同步 I/O、調整 autovacuum、最佳化向量索引、使用 EXPLAIN BUFFERS 分析執行計劃、配置 PgBouncer 或連接池、設定表分區、實現遊標分頁或優化佇列處理時使用。 來源：oakoss/agent-skills。