create_maintenance_plan
Create a reviewed, nontransactional PostgreSQL maintenance plan for operations like vacuum, analyze, reindex, and refresh materialized views. Define schema, target, parallel workers, skip locked, and index cleanup policy.
Instructions
Create a reviewed nontransactional PostgreSQL maintenance plan
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Stable maintenance operation name | |
| parallel | No | VACUUM parallel workers | |
| operation | Yes | Structured maintenance operation | |
| schema_name | Yes | Exact target schema | |
| skip_locked | No | Skip relations that cannot be locked immediately | |
| target_name | Yes | Exact relation or index name | |
| index_cleanup | No | VACUUM index cleanup policy | auto |