Samay is a Lead Solutions Engineer at Citus Data (now part of Microsoft). He works with application developers to scale their Postgres based apps to handle very large data volumes with Citus. He’s been working with Postgres all his professional life and wants to make databases and database performance easier to understand (and optimize) for developers.View the profile
About the talk
RailsConf 2019 - Optimizing your app by understanding your PostgreSQL database by Samay Sharma
This is a sponsored talk by Citus Data.
I’m a Postgres person. Period. After talking to many Rails developers about their application performance, I realized many performance issues can be solved by understanding your database a bit better. So I thought I’d share the statistics Postgres captures for you and how you can use them to find slow queries, un-used indexes, or tables which are not getting vacuumed correctly. This talk will cover Postgres tools and tips for the above, including pgstatstatements, useful catalog tables, and recently added Postgres features such as CREATE STATISTICS.
Buy this talk
Access to all the recordings of the event
Buy this video
With ConferenceCast.tv, you get access to our library of the world's best conference talks.