RezloRezloPrep
Sign Up Free
Production Optimization

Interview Questions

  1. How would you investigate a slow production API?
  2. How do you identify which SQL query is causing the problem?
  3. How do you measure query performance before optimization?
  4. How do you prove that an optimization actually worked?
  5. How would you optimize a query taking 2 seconds?
  6. How would you decide whether to add an index?
  7. What if adding an index improves reads but slows writes?
  8. How does caching change database load?
  9. When would you use Redis instead of optimizing PostgreSQL?
  10. Your resume says PostgreSQL performance improved by 60%. Walk me through exactly how you achieved and measured it.