Скачать или смотреть 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:
https://www.scalingpostgres.com/episo...

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?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

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