Postgres Performance

dashed/claude-marketplace·by Alberto Leal

PostgreSQL query & performance tuning. Use when a query is slow, reading an `EXPLAIN [ANALYZE]` plan (scan/join nodes, estimate skew), choosing an index type/columns (btree/GIN/GiST/SP-GiST/BRIN/hash; partial/expression/covering), fixing planner estimates with statistics, diagnosing MVCC bloat/VACUUM/autovacuum lag, or tuning planner GUCs (`random_page_cost`, `work_mem`). Includes `(pgNN+)` annotations. Tuning only — client -> psql, SQL -> postgres-sql, config -> postgres-admin.