Check out pgtune (https://pgtune.leopard.in.ua/#/) if simple config tuning is what you are looking for. It is probably more valuable than this blog post.
The point is that the pgtune could and should force you to check the config options in documentation and it actually addresses your current setup. RTFM.
Values in the post are pretty arbitrary and useless as their comments in postgresql.conf used to be.
I am using PostgreSQL in production since 7.4 and the best source of performance tuning tips for me has been PostgreSQL 9.0 High Performance by Gregory Smith. These days PostgreSQL wiki is pretty good as well.
I'd second that book recommendation. I just went through it again on a long plane flight, and much (if not all) of the configuration advice applies to more recent releases as well.
For sure. And although I love pgtune and it's usually my first stop when I'm firing up a new database, it's only really modifying a few parameters when there's a whole host of server configuration tweaks available:
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.
Learning about what goes on under the hood before you blindly change settings some tool spits out doesn't seem like a bad idea I'd say.