gregs1104/pgtune
PostgreSQL configuration wizard observed · 2026-08-28
Health v2 · maintenance only
32/100
- Activity 0
- Release rhythm 35
- Longevity 100
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 6067
- days_rel: n/a
- days_push: 1842
- n_releases_24m: 0
Adoption not part of the score
1088 stars · 93 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
Pgtune is a Python CLI script that generates a tuned PostgreSQL postgresql.conf based on server memory, workload type, and expected connections. It takes an existing config as input and outputs an optimized version for the hardware it will run on.
Use cases
- tune postgresql.conf for my server's RAM
- generate postgres config for an OLTP workload
- optimize postgres settings for a web application server
- calculate shared_buffers and work_mem for my database
- reconfigure postgres defaults for a data warehouse
- pick postgres settings for a given number of connections
When to choose
- you want a quick, hardware-aware starting point for postgresql.conf
- you're provisioning a new PostgreSQL server and the defaults are too conservative
- you need a scriptable, offline config generator
When to avoid
- you need per-query or runtime adaptive tuning
- you want a maintained web wizard (consider pgtune.leopard.in.ua or pgconfig.org instead)
- you need support for very recent PostgreSQL versions, as this project's last release was 2021
Facets
cli-tool · maturity maintenance
configuration-management database developer-tools cli databases developer-tools performance windows python cli postgresql tuning postgresql-conf database-configuration sysadmin command-line linux macos
1 source
- readme: https://github.com/gregs1104/pgtune · fetched 2026-08-28 · a9104ff7b8f3
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| gregs1104/pgtune | main | 32 |
For agents
markdown · JSON · MCP: product_card(name="gregs1104/pgtune")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem