pgtune
Pgtune - tuning PostgreSQL config by your hardware
What is pgtune?
Pgtune - tuning PostgreSQL config by your hardware
Overview of pgtune
What it is
Pgtune is a tool for tuning PostgreSQL configuration based on your hardware specifications. It is a web-based application that generates optimized PostgreSQL configuration parameters by taking into account the system's memory, CPU, storage type, and number of connections. The project is based on the original pgtune and is available as an open-source repository on GitHub.
Key features
- Generates PostgreSQL configuration settings based on user-provided hardware parameters (memory, CPU, storage type, number of connections).
- Provides a web interface for inputting hardware specifications and viewing the resulting configuration.
- Includes unit tests and end-to-end (e2e) smoke tests to ensure correctness.
- Stores generated configurations as snapshots for review and comparison during development.
- Supports development mode with hot reloading and production builds with prerendered pages and service worker.
Use cases
- Database administrators who need to quickly generate a baseline PostgreSQL configuration for a new server.
- Developers setting up PostgreSQL in development or production environments who want to optimize performance based on available hardware.
- System administrators tuning PostgreSQL for specific workloads (e.g., OLTP, reporting) by adjusting hardware inputs.
Getting started
To run Pgtune in development mode, you need Node.js and Yarn installed. Then execute the following commands in your terminal:$ yarn # get all node.js deps$ yarn dev # start server on 5173 portFor a production build with prerendered pages and service worker, use:$ yarn build && yarn preview
License and pricing
Pgtune is licensed under the MIT License. It is open-source and free to use.
Based on the project's public README and repository metadata.