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

To get the show notes as well as get notified of new episodes, visit:

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.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:27 - Speeding up recovery & VACUUM in Postgres 14
03:48 - Faster Bulk Insertion to Foreign Tables - Introduction to PostgreSQL 14 Committed Features
06:13 - Speeding up SQL queries by orders of magnitude using UNION
08:39 - How the PostgreSQL query optimizer works
09:57 - How to check and resolve Bloat in PostgreSQL
12:21 - Waiting for PostgreSQL 14 – Allow configurable LZ4 TOAST compression.
13:20 - Sharding Postgres on a single Citus node, how why & when
15:03 - [YouTube] EDB Channel
15:19 - Explaining Your Postgres Query Performance
15:58 - Ansible Collection for PostgreSQL and EDB Components
16:48 - No space left on device
18:06 - Performance Improvements in GEOS
18:47 - How to Get the Status of a Cloud Native PostgreSQL Cluster
19:11 - Julien Riou
19:23 - Outro

#postgres #postgresql