pgTune

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

Workload profile
Server resources

You can adjust the inputs and generate a new recommendation without leaving this page.

How it works

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

First step

Fill in the form and generate a recommendation. The result will appear here, while the form remains available for quick adjustments.

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.