Scaling Postgres Episode 157 auto_explain Overhead | Postgres Data Lake | Citus Shard Rebalance | SSL Authentication

In this episode of Scaling Postgres, we discuss auto_explain's overhead, setting up a Postgres data lake, rebalancing a Citus shared database and implementing SSL authentication.

Content Discussed

• Can auto_explain (with timing) have low overhead?
• Build your own “data lake” for reporting purposes in a multi-services environment
• Scaling out Postgres with the Citus open source shard rebalancer
• Setting up SSL authentication for PostgreSQL
• Enhancing PostgreSQL 13 Security with the CIS Benchmark
• How the EDB Postgres STIGs Can be Used to Secure Your PostgreSQL Database
• Monitoring PostgreSQL with Nagios and Checkmk
• Musings of a PostgreSQL Data Pontiff Episode 1
• Musings of a PostgreSQL Data Pontiff Episode 2 - Hot Magick; Analytics and Graphical Output with PL/R
• Traveling Salesman problem with PostGIS and pgRouting
• Introducing pg_query 2.0: The easiest way to parse Postgres queries
• Cloud Native PostgreSQL for Application Developers
• Announcing the Crunchy Postgres Operator 4.6.0 with rolling updates, pod tolerations, node affinity and more
• Anastasia Lubennikova

YouTube Video