pgTune

Generate PostgreSQL tuning recommendations from your workload profile and server resources.

Workload profile
Server resources

How it works

pgAssistant uses the well-known pgTune algorithm to estimate a sensible PostgreSQL configuration based on your workload and server resources.

You can learn more about pgTune here: https://pgtune.leopard.in.ua/

Review generated settings carefully before applying them in production, especially shared_buffers, work_mem, effective_cache_size, and max_connections.