Episode 200 5 Minutes of Postgres | Unnest | SCRAM | Multi-master Review

<p>In this episode of Scaling Postgres, we discuss the new series 5 minutes of Postgres, using unnest, switching to SCRAM authentication and reviewing multi-master solutions.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ol> <li><a href= "https://pganalyze.com/blog/5mins-postgres-statistics-bad-query-plans-pghintplan"> 5mins of Postgres E1: Using Postgres statistics to improve bad query plans, pg_hint_plan extension</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-using-unnest-generate-series-postgis"> 5mins of Postgres E2: Using unnest(..), generate_series(), and PostGIS</a></li> <li><a href= "https://www.atdatabases.org/blog/2022/01/21/optimizing-postgres-using-unnest"> Postgres UNNEST cheat sheet for bulk operations</a></li> <li><a href= "https://www.percona.com/blog/postgresql-14-and-recent-scram-authentication-changes-should-i-migrate-to-scram/"> PostgreSQL 14 and Recent SCRAM Authentication Changes – Should I Migrate to SCRAM?</a></li> <li><a href= "https://www.enterprisedb.com/blog/pg-phriday-replication-engine-potpourri"> PG Phriday: Replication Engine Potpourri</a></li> <li><a href= "https://dataegret.com/2022/01/accelerating-vacuum-in-postgres/">Accelerating VACUUM in Postgres</a></li> <li><a href= "https://heap.io/blog/lessons-from-completing-a-few-advent-of-code-problems-in-postgres-sql"> Postgres SQL Lessons From Advent of Code Challenges</a></li> <li><a href= "https://andreas.scherbaum.la/blog/archives/1106-Not-so-equal-texts-in-PostgreSQL-and-how-to-compare-texts-in-a-more-elaborate-way.html"> Not so equal texts in PostgreSQL - and how to compare texts in a more elaborate way</a></li> <li><a href= "https://www.jkatz05.com/post/postgres/postgres-read-only/">"Read-Only" Mode for PostgreSQL</a></li> <li><a href= "https://www.depesz.com/2022/01/28/waiting-for-postgresql-15-add-header-support-to-copy-text-format/"> Waiting for PostgreSQL 15 – Add HEADER support to COPY text format</a></li> <li><a href= "https://bl