The guide describes all the steps required to safely migrate your Heroku PostgreSQL database to AWS RDS. Zero prior AWS experience is required to complete the guide. All the steps are described in a detailed way together with code snippets and AWS console screenshots. The guide is written in a programming language-agnostic way, so it applies to all the backend technologies hosted on Heroku.| Rails, PostgreSQL Performance Audit and Tuning Consultant for Hire
Interpreting the output of SQL EXPLAIN ANALYZE might seem like dark magic at first. I'm starting a series of blog posts where I'll be well... explaining it based on common use cases from web applications. Read on if you've ever wanted to start using EXPLAIN ANALYZE for debugging slow PostgreSQL queries but did not manage to wrap your head around it. In the first part, we'll discuss how the PostgreSQL query planner decides whether to use an index.| Rails, PostgreSQL Performance Audit and Tuning Consultant for Hire