Scaling Postgres Episode 196 Easy Recursive CTE | Zheap Undo | High Availability | Loading Data

Описание: 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 easily writing a recursive CTE, the zheap undo capability, high availability considerations and fast ways to load data.

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:41 - Learn how to write SQL recursive CTE in 5 steps
03:10 - zheap UNDO logs discarding in PostgreSQL
07:02 - Postgres HA: roles are dynamic
09:33 - The Fastest Way To Load Data Into Postgres With Ruby on Rails
12:15 - Explore the new SEARCH and CYCLE features in PostgreSQL 14
13:57 - PostGIS Nearest Neighbor Syntax
14:15 - UK COVID-19 dashboard built using Postgres and Citus for millions of users
14:59 - Manage encryption keys with PostgreSQL TDE
15:41 - High Availability and Disaster Recovery Recipes for PostgreSQL on Kubernetes
16:15 - Ashutosh Bapat
16:25 - Rubber Duck Dev Show Episode 22 | Code Quality Analyzers
16:48 - Outro

#postgres #postgresql