Recommend Postgres conf
recommend_postgres_confCompute PostgreSQL configuration recommendations based on system resources and workload type, without accessing any database.
Instructions
Compute pgtune-style postgresql.conf recommendations. Pure calculator — touches no database. Given total_ram_mb (required), cpu_count (default 4), workload (one of web/oltp/dw/desktop/mixed, default mixed), storage (one of ssd/hdd/san, default ssd), and an optional max_connections override, returns recommended values for shared_buffers, effective_cache_size, work_mem, maintenance_work_mem, wal_buffers, min_wal_size/max_wal_size, checkpoint_completion_target, default_statistics_target, random_page_cost, effective_io_concurrency, and the parallel-worker knobs. Memory fields are postgres-ready strings; settings is the same data as a flat {guc: value} dict for direct rendering. Pair with audit_settings (audit first, then size).
Example: recommend_postgres_conf(total_ram_mb=16384, cpu_count=8, workload='oltp', storage='ssd')
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| storage | No | ssd | |
| workload | No | mixed | |
| cpu_count | No | ||
| total_ram_mb | Yes | ||
| max_connections | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||