Scaling Postgres Episode 190 Hello Babelfish | Planner Deconstruction | Exist & Not Exist | SQL Fun

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss the open sourcing of Babelfish, deconstructing the Postgres planner, when to avoid exist & not exist and having fun with SQL.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:28 - Announcing Open Source Babelfish for PostgreSQL: An Accelerator for SQL Server Migration
02:12 - Goodbye Microsoft SQL Server, Hello Babelfish
03:18 - How we deconstructed the Postgres planner to find indexing opportunities
05:15 - Three Cases Against IF NOT EXISTS / IF EXISTS in Postgres DDL
07:38 - Fun with SQL in Postgres: Finding Revenue Accrued Per Day
08:12 - Exploring PL/pgSQL part two: implementing a Forth-like interpreter
08:34 - The PostgreSQL Timeline Concept
09:12 - Patroni & etcd in High Availability Environments
10:32 - Can't Resize your Postgres Kubernetes Volume? No Problem!
10:52 - Vehicle routing optimization with Amazon Aurora PostgreSQL-Compatible Edition
11:30 - Tatsuro Yamada
11:41 - Rubber Duck Dev Show Episode 19 | How Much Time Should You Spend Planning
12:06 - Outro

#postgres #postgresql