Hacker GitHub

← All repos

jfcoz/postgresqltuner

View on GitHub ↗ ★ 2,704 Perl

Simple script to analyse your PostgreSQL database configuration, and give tuning advice

10 mentions on Hacker News by 6 people: 2 stories, 8 comments · first 2019-03-18 · latest 2025-04-18

Mentions per year 10 mentions · busiest year 2019 (5)
20082026
AllStoriesComments NewestTopOldest
  1. …estimated RAM usage) really good. [1] https://www.pgedge.com/blog/postgresql-performance-tuning [2] https://github.com/jfcoz/postgresqltuner
    comment by rtp4me · 2025-04-18 · in Memory Size Matters to PostgreSQL
  2. …This thread appears to be such an example. [1] - https://github.com/major/MySQLTuner-perl [2] - https://github.com/jfcoz/postgresqltuner
    comment by LinuxBender · 2022-01-12 · in In MySQL, use “utf8mb4” instead of “utf8” (2016)
  3. …[1] or do most DBA's here just apply their own learned optimizations manually? [1] - https://github.com/jfcoz/postgresqltuner
    comment by LinuxBender · 2021-04-07 · in Things I hate about PostgreSQL (2020)
  4. …in the other technologies. [1][2] These tools are not perfect, but may be informative. [1] - https://github.com/jfcoz/postgresqltuner [2] - https://github.com/major/MySQLTuner-perl
    comment by LinuxBender · 2021-03-10 · in Ask HN: What is the future for Oracle DBAs?
  5. Belated. https://github.com/jfcoz/postgresqltuner
    comment by evadne · 2019-11-06 · in Postgres Health Check and SQL Performance Analysis
  6. …concerned on upkeep and fragmentation. I also noticed postgresql documentation talking about using https://github.com/jfcoz/postgresqltuner Any compares and contrasts available? I'm not running a production instance so tuning is gratuitous…
    comment by tejtm · 2019-03-19 · in Vertically Scaling PostgreSQL
  7. …seems to be in the repo. Looks like it just installs some apt packages and adds the script file: https://github.com/jfcoz/postgresqltuner/blob/master/Dockerf...
    comment by zbuttram · 2019-03-18 · in Simple script to analyse your PostgreSQL database config, give tuning advice
  8. Would this be caught or suggested in the postgres tuner script? [1] [1] - https://github.com/jfcoz/postgresqltuner
    comment by LinuxBender · 2019-03-18 · in A single PostgreSQL config change improved slow query performance by 50x