4 ms·

Check out pgtune (https://pgtune.leopard.in.ua/#/ https://pgtune.leopard.in.ua/#/) if simple config tuning is what you are looking for. It is probably more valu

by ps 8y ago

Check out pgtune (https://pgtune.leopard.in.ua/#/ https://pgtune.leopard.in.ua/#/) if simple config tuning is what you are looking for. It is probably more valuable than this blog post.

dewey 8y ago
> It is probably more valuable than this blog post. 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.
- bshipp 8y ago
  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: https://www.postgresql.org/docs/current/runtime-config.html https://www.postgresql.org/docs/current/runtime-config.html
- ps 8y ago
  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.
  - rch 8y ago
    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.
GordonS 8y ago
> It is probably more valuable than this blog post They do different things - pgTune tells you how to configure your system, this blog post tells you why.
tejtm 8y ago
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 https://github.com/jfcoz/postgresqltuner Any compares and contrasts available? I'm not running a production instance so tuning is gratuitous but nice.

by ps 8y ago

Check out pgtune (https://pgtune.leopard.in.ua/#/ https://pgtune.leopard.in.ua/#/) if simple config tuning is what you are looking for. It is probably more valuable than this blog post.

dewey 8y ago

> It is probably more valuable than this blog post. 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.

bshipp 8y ago
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: https://www.postgresql.org/docs/current/runtime-config.html https://www.postgresql.org/docs/current/runtime-config.html
ps 8y ago
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.
- rch 8y ago
  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.

GordonS 8y ago

> It is probably more valuable than this blog post They do different things - pgTune tells you how to configure your system, this blog post tells you why.

tejtm 8y ago

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 https://github.com/jfcoz/postgresqltuner Any compares and contrasts available? I'm not running a production instance so tuning is gratuitous but nice.