Scaling Postgres Episode 53 | Query Planner | BRIN Indexes | Approximate Algorithms | Delayed Replication

In this episode of Scaling Postgres, we review articles covering the Postgres query planner, BRIN indexes, approximate algorithms, and the uses of delayed replication.

Content Discussed

• Debugging the Postgres query planner
• PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage
• Approximation algorithms for your database
• How we used delayed replication for disaster recovery with PostgreSQL
• Webinar: Achieving High Availability with PostgreSQL [Follow Up]
• The Current State of Open Source Backup Management for PostgreSQL
• pgBackRest - Performing Backups on a Standby Cluster
• “Exclusive backup” method is deprecated – what now?
• Using parallelism for queries from PL functions in PostgreSQL 10
• Parallel queries in PostgreSQL
• Why you should use a relational database instead of NoSQL for your IoT application

YouTube Video