Biggish Data With Rails and Postgresql

Once your database hits a few hundred million rows normal ActiveRecord conventions don't work so well. find yourself in a new world. One where calling count() can bring your app to its knees. One where migrations can take all day.

This talk will show you how to work with big datasets in Rails and Postgresql. We'll show how normal conventions break down, and offer practical real-world advice on maintaining performance, doing maintenance, and tuning rails for optimal DB performance.

Starr likes building things that make people happy, usually with Ruby and Javascript. (He once built a bookshelf, but it was crooked and made noone happy.) He's the cofounder of He lives in Guadalajara, Mexico and speaks very bad Spanish.

Help us caption & translate this video!

RailsConf 2014