PostgreSQL Performance

Use When

• PostgreSQL query performance and storage internals sourced from "Introduction to PostgreSQL for the Data Professional" (Booz & Fritchey). Covers EXPLAIN ANALYZE (reading node types, costs, buffers), all index types (B-tree, GIN, GiST, BRIN, partial, functional, covering, composite), MVCC internals, VACUUM/ANALYZE configuration, work_mem tuning, and slow query diagnosis. Companion to postgresql-fundamentals and postgresql-administration.
• The task needs reusable judgment, domain constraints, or a proven workflow rather than ad hoc advice.

Do Not Use When

• The task is unrelated to postgresql-performance or would be better handled by a more specific companion skill.
• The request only needs a trivial answer and none of this skill's constraints or references materially help.

Required Inputs

• Gather relevant project context, constraints, and the concrete problem to solve.
• Confirm the desired deliverable: design, code, review, migration plan, audit, or documentation.

Workflow