Скачать или смотреть Scaling Postgres Episode 201 JSONB Performance, Bidirectional Replication, Recent Records, PG14 JSON

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 how to generate shaped sample data, track changes between Postgres verions, identify missed bottlenecks and use different index types.

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:29 - Postgres large JSON value query performance
02:36 - 5mins of Postgres E3: Postgres performance cliffs with large JSONB values and TOAST
03:49 - PG Phriday: Nominally Bidirectional
06:03 - Select the most recent record (of many items) with PostgreSQL
07:48 - Working With JSON in Postgres 14
09:33 - How to gain insight into the pg_stat_replication_slots view by examining logical replication
10:18 - Automatic partition creation in PostgreSQL
11:19 - Secure Permissions for pgBackRest
12:02 - PostgreSQL Timestamps and Timezones: What You Need to Know—and What You Don’t
12:29 - PostgreSQL Timestamps and Timezones: How to Navigate the Interval Minefield
12:56 - Creating a Postgres Foreign Data Wrapper
13:41 - How to use regular expression group quantifiers in PostgreSQL
14:16 - Álvaro Herrera
14:27 - Rubber Duck Dev Show Episode 28 | Exploring the Jamstack
14:51 - Outro

#postgres #postgresql