1. Advanced Postgres Performance Tips

  2. Reading a Postgres EXPLAIN ANALYZE Query Plan

  3. ActiveRecord Eager Loading with Query Objects and Decorators

  4. Postgres Window Functions

  5. Why Postgres Won't Always Use an Index

  6. Back to Basics: Writing SQL Queries

  7. Refactoring Ruby Iteration Patterns to the Database

  8. Extract Mostly-Constant Data from the Database

  9. A Grand Piano for Your Violin

  10. depends

  11. don't be normal