
Scaling Postgres Episode 158 Vacuum Speed Up | Faster Foreign Tables | Fast Queries With Union | Query Optimizer
Get New Episodes Weekly!
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