postgresqltuner

Interesting read, but I find it very lacking. PGSQL memory consists of lots of parts; shared_buffers, work_mem, maintenance_work_men, OS Cache size, etc. For those who are interested in a deeper Postgresql tuning tutorial, I suggest this[1] as it highlights a number of important tuning options - specifically for PGSQL 17. Once your DB has been running for a while, run the postgresql-tuner app[2] to see if you have correctly applied RAM settings[2]. The repo has been around for a long time, but I find the recommendations (especially the estimated RAM usage) really good. [1] https://www.pgedge.com/blog/postgresql-performance-tuning [2] https://github.com/jfcoz/postgresqltuner

Would the DBA's on this thread consider committing code to the MySQL [1] and Postgres [2] tuner scripts that give new DBA's all your learned advise and battle hardening experience? This thread appears to be such an example. [1] - https://github.com/major/MySQLTuner-perl [2] - https://github.com/jfcoz/postgresqltuner

Out of curiosity, do these optimizations / calculations find their way into scripts like postgresqltuner [1] or do most DBA's here just apply their own learned optimizations manually? [1] - https://github.com/jfcoz/postgresqltuner

I am not a DBA but I work with many of them. Most of the DBA's I currently work with have/had Oracle experience, but they are currently supporting MySQL. Some of them also know Postgres. There will always be a need for database engineers and architects. Even knowing how to optimize queries can be quite valuable to a company. Already being an Oracle DBA it should be rather easy for her to pick up the open source databases and widen her career opportunities. IIRC there are even blogs where former Oracle DBA's wrote how-to's that summarize command equivalents for Oracle -> MySQL and Oracle -> Postgres so that if you already know one, you can see the equivalent commands in the corresponding technologies. As a side note, there are also some git repos that have optimizing scripts for MySQL and Postgres that may also help her learn some of

Belated. https://github.com/jfcoz/postgresqltuner

I was just back looking at pgtune after being distracted for a number of years and felt a twinge 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 but nice.

Also the Dockerfile 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...

Would this be caught or suggested in the postgres tuner script? [1] [1] - https://github.com/jfcoz/postgresqltuner