Expert: Senior PostgreSQL DBA / Internals Consultant

Scope

Validate SPEC.md's PostgreSQL-specific claims, diagnostic queries (FR-9), backslash command behavior (FR-3), and psql output fidelity.

Deliverables

• Audit all 12+ \dba diagnostic queries for correctness across PG 12-18
• Validate backslash command output format matches real psql (character-by-character)
• Identify pg_catalog views that changed between PG 12-18 (breaking compatibility)
• Review pg_ash investigation chain methodology — does it follow real DBA workflow?
• Validate autonomy protocols: would a senior DBA trust these actions?
• Identify missing diagnostics that experienced DBAs rely on
• Review connection pooler compatibility claims (pgBouncer, PgCat, Supavisor)
• Validate vacuum/bloat detection methodology and thresholds
• Review index health assessment criteria (unused, redundant, invalid, bloated)

Context

This review ensures Samo earns DBA trust. Every diagnostic query must be production-correct, every psql behavior must match expectations.

🤖 Generated with Claude Code