RailsConf 2017: The Secret Life of SQL: How to Optimize Database Performance by Bryana Knight

RailsConf 2017: The Secret Life of SQL: How to Optimize Database Performance by Bryana Knight
There are a lot of database index and query best practices that sometimes aren't best practices at all. Need all users created this year? No problem! Slap an index over created_at! What about this year's active OR pending users, sorted by username? Are we still covered index-wise? Is the query as fast with 20 million users? Common rules of thumb for indexing and query crafting aren’t black and white. We'll discuss how to track down these exceptional cases and walk through some real examples. You'll leave so well equipped to improve performance, you won't be able to optimize fast enough!

[@dkennell998]

I'd always been confused about what exactly indexes were; thanks for breaking it down so nicely!

[@jasdeepsinghgrover2470]

Another rule... Always remember your functional dependencies... Conditions on dependent columns can be converted to conditions on independent columns which generally have indexes. Like to get all apples a redundant condition on object type to be fruit can help

[@m.purushothamreddy4901]

nice talk thanks for the knowledge.

[@alfredoscoppa9455]

Awesome talk! I would add that PG planner is probably very smart and that could be the reason why PG intentionally excluded something like index hint.

[@codyelhard8012]

I thought indexes were magic before this video

[@luisalfonzogonzalez2265]

She is awesome!!! LOVED HER EXPLANATION

[@grawlixes]

This talk was great. Thanks!