review_settings
Analyze PostgreSQL configuration settings to identify performance issues and receive optimization recommendations for memory, checkpoints, WAL, autovacuum, and connection parameters.
Instructions
Review PostgreSQL configuration settings and get recommendations.
Analyzes key performance-related settings:
Memory settings (shared_buffers, work_mem, etc.)
Checkpoint settings
WAL settings
Autovacuum settings
Connection settings
Compares against best practices and system resources.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| category | No | Category of settings to review | all |
| include_all_settings | No | Include all settings, not just performance-related ones |
Input Schema (JSON Schema)
{
"properties": {
"category": {
"default": "all",
"description": "Category of settings to review",
"enum": [
"all",
"memory",
"checkpoint",
"wal",
"autovacuum",
"connections"
],
"type": "string"
},
"include_all_settings": {
"default": false,
"description": "Include all settings, not just performance-related ones",
"type": "boolean"
}
},
"required": [],
"type": "object"
}