PostgreSQL Configuration for Humans
Álvaro is a passionate database and software developer. He has been an almost exclusive user of PostgreSQL, as THE database, for more than 15 years. Founder of OnGres, he is dedicated to R&D in databases. Álvaro founded ToroDB, previously the “Billion Tables Project” and keeps working on innovative open source solutions for databases, specially PostgreSQL. On his free time he also contributes to open source and PostgreSQL, like SCRAM's support in PostgreSQL's JDBC driver.
He is a frequent speaker at PostgreSQL, database and Java conferences. Álvaro created the Spanish PostgreSQL user group, one of the largest in the world, with 750+ members.
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 to make PostgreSQL configuration possible for HUMANS, and learn the best practices for tuning several relevant postgresql.conf parameters.
- 50 min
- PostgresConf US 2018
- Operations and Administration