PostgreSQL Configuration for Humans

E084eb5b13255d30b3800d7afb251147?s=47 OnGres
October 27, 2017

PostgreSQL Configuration for Humans

Video: https://www.youtube.com/watch?v=IFIXpm73qtk

PostgreSQL is the world’s most advanced open source database. Indeed! With around 270 configuration parameters in postgresql.conf, plus all the knobs in pg_hba.conf, it is definitely ADVANCED!

How many parameters do you tune? 1? 8? 32? Anyone ever tuned more than 64?

No tuning means below par performance. But how to start? Which parameters to tune? What are the appropriate values? Is there a tool --not just an editor like vim or emacs-- to help users manage the 700-line postgresql.conf file?

Join this talk to understand the performance advantages of appropriately tuning your postgresql.conf file, showcase a new free tool (https://postgresqlco.nf) to make PostgreSQL configuration possible for HUMANS, and learn the best practices for tuning several relevant postgresql.conf parameters.

Check out https://postgresqlco.nf !

E084eb5b13255d30b3800d7afb251147?s=128

OnGres

October 27, 2017
Tweet