Scaling Postgres Episode 201 JSONB Performance, Bidirectional Replication, Most Recent Record, PG14 JSON

In this episode of Scaling Postgres, we discuss JSONB performance, bidirectional replication, getting the most recent record and using JSON in Postgres 14.

Content Discussed

• Postgres large JSON value query performance
• 5mins of Postgres E3: Postgres performance cliffs with large JSONB values and TOAST
• PG Phriday: Nominally Bidirectional
• Select the most recent record (of many items) with PostgreSQL
• Working With JSON in Postgres 14
• How to gain insight into the pg_stat_replication_slots view by examining logical replication
• Automatic partition creation in PostgreSQL
• Secure Permissions for pgBackRest
• PostgreSQL Timestamps and Timezones: What You Need to Know—and What You Don’t
• PostgreSQL Timestamps and Timezones: How to Navigate the Interval Minefield
• Creating a Postgres Foreign Data Wrapper
• How to use regular expression group quantifiers in PostgreSQL
• Álvaro Herrera
• Rubber Duck Dev Show Episode 28 | Exploring the Jamstack

YouTube Video