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

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.pgmustard.com/blog/auto-explain-overhead-with-timing">https://www.pgmustard.com/blog/auto-explain-overhead-with-timing</a><br /> <br /> <a href= "https://tech.fretlink.com/build-your-own-data-lake-for-reporting-purposes/"> https://tech.fretlink.com/build-your-own-data-lake-for-reporting-purposes/</a><br /> <br /> <a href= "https://www.citusdata.com/blog/2021/03/13/scaling-out-postgres-with-citus-open-source-shard-rebalancer/"> https://www.citusdata.com/blog/2021/03/13/scaling-out-postgres-with-citus-open-source-shard-rebalancer/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/setting-up-ssl-authentication-for-postgresql/"> https://www.cybertec-postgresql.com/en/setting-up-ssl-authentication-for-postgresql/</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/enhancing-postgresql-13-security-with-the-cis-benchmark-1"> https://blog.crunchydata.com/blog/enhancing-postgresql-13-security-with-the-cis-benchmark-1</a><br /> <br /> <a href= "https://www.enterprisedb.com/blog/how-edb-postgres-stigs-can-be-used-secure-your-postgresql-database"> https://www.enterprisedb.com/blog/how-edb-postgres-stigs-can-be-used-secure-your-postgresql-database</a><br /> <br /> <a href= "https://www.highgo.ca/2021/03/15/monitoring-postgresql-with-nagios-and-checkmk/"> https://www.highgo.ca/2021/03/15/monitoring-postgresql-with-nagios-and-checkmk/</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/musings-of-a-postgresql-data-pontiff"> https://blog.crunchydata.com/blog/musings-of-a-postgresql-data-pontiff</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/episode-2-hot-magick-analytics-and-graphical-output-using-pl/r-with-magick"> https://blog.crunchydata.com/blog/epi