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