Scaling Postgres Episode 69 | Performance Training | JSON Path | Hypothetical Indexes | Interpolation

In this episode of Scaling Postgres, we discuss performance training, SQL/JSON path support, hypothetical indexes and linear interpolation of data.

Content Discussed

• PostgreSQL 11.4, 10.9, 9.6.14, 9.5.18, 9.4.23, and 12 Beta 2 Released!
• Explaining CVE-2019-10164 + PostgreSQL Security Best Practices
• CVE-2019-10164 Who's affected and how to protect your systems.
• [YouTube] PostgreSQL In-Depth Training: Performance Part 1
• [YouTube] PostgreSQL In-Depth Training: Performance Part 2
• Postgres 12 highlight - SQL/JSON path
• Hypothetical Indexes in PostgreSQL
• Per-project Postgres
• Linear Interpolation with PostgreSQL
• Physical Replication Mechanisms in PostgreSQL
• PostgreSQL Streaming Replication
• Install PostgreSQL 9.6 with Transparent Data Encryption
• Announcing Timescale Cloud: The first fully-managed time-series database service that runs on AWS, GCP, and Azure

YouTube Video