Scaling Postgres Episode 158 Vacuum Speed Up | Faster Foreign Tables | Fast Queries With Union | Query Optimizer

In this episode of Scaling Postgres, we discuss a vacuum speed up and faster foreign tables in Postgres 14, running faster queries with union and learning about the query optimizer.

Content Discussed

• Speeding up recovery & VACUUM in Postgres 14
• Faster Bulk Insertion to Foreign Tables - Introduction to PostgreSQL 14 Committed Features
• Speeding up SQL queries by orders of magnitude using UNION
• How the PostgreSQL query optimizer works
• How to check and resolve Bloat in PostgreSQL
• Waiting for PostgreSQL 14 – Allow configurable LZ4 TOAST compression.
• Sharding Postgres on a single Citus node, how why & when
• [YouTube] EDB Channel
• Explaining Your Postgres Query Performance
• Ansible Collection for PostgreSQL and EDB Components
• No space left on device
• Performance Improvements in GEOS
• How to Get the Status of a Cloud Native PostgreSQL Cluster
• Julien Riou

YouTube Video