The Future of MySQL is Postgres? | Scaling Postgres 313

In this episode of Scaling Postgres, we discuss whether the future of MySQL is Postgres, how to use recursive CTEs, work on OrioleDB, and PG17 performance improvements.

Content Discussed

• The Future of MySQL is Postgres
• Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3
• Oriole joins Supabase
• Waiting for Postgres 17: Faster B-Tree Index Scans for IN(...) lists and ANY =
• Massive DELETEs
• Auto-archiving and Data Retention Management in Postgres with pg_partman
• PGXN v2/Architecture
• 10 psql Commands That Will Make Your Life Easier
• Announcing PGDSAT to satisfy CIS benchmarks for PostgreSQL
• A Deeper Look Inside PostgreSQL Visibility Check Mechanism
• PostgreSQL Internals Part 3: Understanding Processes in PostgreSQL
• An unfair advantage: multi-tenant queues in Postgres
• How to calculate percentiles with SQL PERCENTILE_CONT
• Unlock PostgreSQL Superpowers with pg_tle
• Installing pg_tle on Ubuntu: A Quick Guide
• PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type.
• Using PL/Java: need for clarifications
• How to run TLS regression test in PostgreSQL
• DBaaG with SQL/PGQ
• About Talk Selection for POSETTE: An Event for Postgres 2024
• It's back on September 11th in London, England!!
• Back from PGConf.DE 2024
• PgTraining Free Online Event: Material Available
• Introducing Snowflake Sequences in a Postgres Extension

YouTube Video

Podcast Audio