Presented by:

Álvaro is a passionate database and software developer. Founder and CEO of OnGres, an “ON postGRES” startup. Álvaro has been dedicated to PostgreSQL and R&D in databases since two decades ago.

Álvaro is at heart an open source advocate and developer. Well-known member of the PostgreSQL Community, he has founded the non-profit Fundación PostgreSQL and the Spanish PostgreSQL User Group.

You can find him frequently speaking at PostgreSQL, database, cloud, and Java conferences. Every year, Álvaro travels approximately three-four times around the globe—in 2020, he will hit the milestone of having delivered 100 tech talks.

AWS Data Hero (2019)

Website: aht.es.

No video of the event yet, sorry!
Download the Slides

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.

Date:
Duration:
50 min
Room:
Conference:
PostgresConf US 2018
Language:
English
Track:
Operations and Administration
Difficulty:
Medium