Duration 40:36
16+
Play
Video

RailsConf 2019 - Optimizing your app by understanding your PostgreSQL database by Samay Sharma

Samay Sharma
Senior Software Engineering Manager at Microsoft
  • Video
  • Video
RailsConf 2019
April 30, 2019, Minneapolis, USA
RailsConf 2019
Video
RailsConf 2019 - Optimizing your app by understanding your PostgreSQL database by Samay Sharma
Available
In cart
Free
Free
Free
Free
Free
Free
Add to favorites
1.3 K
I like 0
I dislike 0
Available
In cart
Free
Free
Free
Free
Free
Free
  • Description
  • Discussion

About speaker

Samay Sharma
Senior Software Engineering Manager at Microsoft

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.

Share

Cackle comments for the website

Buy this talk

Access to the talk “RailsConf 2019 - Optimizing your app by understanding your PostgreSQL database by Samay Sharma”
Available
In cart
Free
Free
Free
Free
Free
Free

Access to all the recordings of the event

Get access to all videos “RailsConf 2019”
Available
In cart
Free
Free
Free
Free
Free
Free
Ticket

Interested in topic “Software development”?

You might be interested in videos from this event

September 28, 2018
Moscow
16
159
app store, apps, development, google play, mobile, soft

Similar talks

Eric Niebler
Software Engineer at Facebook
Available
In cart
Free
Free
Free
Free
Free
Free
Bjarne Stroustrup
Managing Director at Morgan Stanley
Available
In cart
Free
Free
Free
Free
Free
Free
Titus Winters
C++ Codebase Cultivator at Google
Available
In cart
Free
Free
Free
Free
Free
Free

Buy this video

Video

Access to the talk “RailsConf 2019 - Optimizing your app by understanding your PostgreSQL database by Samay Sharma”
Available
In cart
Free
Free
Free
Free
Free
Free

Conference Cast

With ConferenceCast.tv, you get access to our library of the world's best conference talks.

Conference Cast
558 conferences
22059 speakers
8190 hours of content