Curious about how to tune PostgreSQL and your Linux kernel to get the best performance out of your database? Come join Payal Singh of OmniTI as she delivers a practical guide to optimizing your database's environment for its workload.
"Essential PostgreSQL Performance Tuning"
Looking at the list of kernel and postgresql.conf parameters, tuning your PostgreSQL database may seem like a daunting task. While each parameter has a role to play, in most scenarios just a handful of these end up impacting performance the most. This talk aims to be a quick practical guide to tuning your PostgreSQL cluster to get the best possible performance with the least effort, with special emphasis on kernel tuning. Along the way we will look at the most commonly encountered gotchas when setting up a new PostgreSQL cluster or migrating an existing one. Also discussed are approaches for performance comparison and a brief look at automated tuning tools.
July 26, 2018 - At Knotel (1 State St, 26th Flr, New York, NY 10004)
6:30 - 6:50pm - Networking
6:50 - 7:00pm - Introductions
7:00pm - The Main Event!
8:15pm - Grab drinks at...