# gregs1104/pgtune

PostgreSQL configuration wizard

Repository: https://github.com/gregs1104/pgtune
Canonical: https://ross.abutalabs.com/products/gregs1104-pgtune
Homepage: http://pgfoundry.org/projects/pgtune/
Language: Python
License: BSD-3-Clause
License Family: permissive
Last push: 2021-08-17T05:31:55+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 6067, "days_push": 1842, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1088, forks 93 (observed 2026-08-28T04:03:32.490064+00:00)

## What it is
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
- artifact type: cli-tool
- maturity: maintenance
- function: configuration-management, database, developer-tools, cli
- domain: databases, developer-tools, performance
- platform: windows, python, cli
- tags: postgresql, tuning, postgresql-conf, database-configuration, sysadmin, command-line, linux, macos

## Member repositories
- gregs1104/pgtune (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:32.490064+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:49:21.971550+00:00, confidence not recorded.
  - readme: https://github.com/gregs1104/pgtune (fetched 2026-08-28T04:03:32.490064+00:00, sha a9104ff7b8f3)
- Data as of 2026-08-30T08:39:29.467469+00:00.