Syn Postgres Vacuum

PostgreSQL: autovacuum and bloat control

legendtkl 7dad81d 703 B Updated

File contents

PostgreSQL: autovacuum and bloat control

When to use

Use this skill for autovacuum and bloat control in PostgreSQL. This skill specifically handles autovacuum and bloat control and nothing else in the PostgreSQL family.

Procedure

Diagnose table/index bloat, tune autovacuum_vacuum_scale_factor and cost limits, run VACUUM FULL/pg_repack, and stop transaction-ID wraparound.

Notes

This is the PostgreSQL skill dedicated to autovacuum and bloat control. Sibling skills cover other PostgreSQL capabilities; this one is the right choice only when the task is about autovacuum and bloat control.

legendtkl/agentic-skill-router/tree/main/experiments/dci-compare/synthetic-skills/syn-postgres-vacuum commit 7dad81db20

Frequently asked questions

npx skillmds@latest add legendtkl/syn-postgres-vacuum