Scaling Postgres Episode 21 | Using JSON | Procedures | Concurrency | Kubernetes скачать в хорошем качестве

Scaling Postgres Episode 21 | Using JSON | Procedures | Concurrency | Kubernetes

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 review articles covering how to use JSON & JSONB, procedures, deal with concurrency issues and Kubernetes. 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:33 - Asynchronous Notifications in Postgres 03:41 - Audit logging using JSONB in Postgres 06:00 - [Video] Introduction to JSON data types in PostgreSQL 07:12 - Using procedures for batch geocoding and other batch processing 08:34 - A beginner’s guide to PostgreSQL’s UPDATE and autovacuum 11:27 - Modeling for Concurrency 12:47 - Computing and Caching 13:40 - Should I Run Postgres on Kubernetes? Part I 15:01 - Should I Run Postgres on Kubernetes? Part II 15:59 - Gracefully Scaling to 10k PostgreSQL Connections for $35/mo, Part Three 16:56 - Custom Trigger Based Upgrades for PostgreSQL 18:23 - PostgreSQL Log Analysis with pgBadger 18:51 - Integrating Tools to Manage PostgreSQL in Production 19:17 - Outro #postgres #postgresq