Scaling Postgres Episode 177 Planner Workarounds | Grouping Sets | Lateral Join | Not-So-Easy

In this episode of Scaling Postgres, we discuss ways to work around the planner, working with grouping sets, using a lateral join and not-so-easy Postgres issues.

Content Discussed

• Working Around a Case Where the Postgres Planner Is "Not Very Smart"
• PostgreSQL grouping sets: ROLLUP & CUBE
• A simple example of LATERAL use
• PostgreSQL: Six Not-So-Easy Pieces
• Logical decoding of two-phase commits in PostgreSQL 14
• Using Cert Manager to Deploy TLS for Postgres on Kubernetes
• Bryn Llewellyn
• Rubber Duck Dev Show Episode 7 | Writing Secure Code