Scaling Postgres Episode 201 JSONB Performance, Bidirectional Replication, Recent Records, PG14 JSON скачать в хорошем качестве

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