PostgreSQL for MySQL DBAs Episode 6 – Explaining EXPLAIN (And an Answer to a Bonus Question)

The differences between MySQL and PostgreSQL are often trivial but occasionally there are stark differences.  A MySQL DBA wanting to optimize a query on a PostgreSQL server will hopefully have...