pgtune ☆

« Back to VersTracker

Description:
Tuning wizard for postgresql.conf

Type: Formula | Tracked Since: Dec 28, 2025

Links: Homepage | formulae.brew.sh

Category: Databases

Tags: postgresql database tuning configuration performance

Install: brew install pgtune

About:
Pgtune is a command-line utility that assists in generating optimized configuration settings for PostgreSQL's postgresql.conf file. By analyzing system resources like available memory and CPU count, it provides tailored recommendations to improve database performance. This tool simplifies the complex task of tuning a database for specific hardware environments.

Key Features:

Automated configuration generation based on system hardware
Supports multiple DB workload types (e.g., web, OLTP, mixed)
Simple command-line interface for quick tuning
Generates safe, conservative settings by default

Use Cases:

Initial setup of a new PostgreSQL instance
Optimizing database performance after hardware upgrades
Benchmarking different workload profiles on the same hardware

Alternatives:

postgresqltuner – Postgresqltuner is a Perl script that analyzes an existing running database to suggest improvements, whereas Pgtune generates a new configuration file from scratch based on hardware specs.
pg_config – pg_config is a standard PostgreSQL utility for finding build and configuration parameters, but it does not provide tuning recommendations.

Version History

Detected	Version	Rev	Change	Commit