Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: 5mins of Postgres E1: Using Postgres statistics to improve bad query plans, pg_hint_plan extension 5mins of Postgres E2: Using unnest(..), generate_series(), and PostGIS Postgres UNNEST cheat sheet for bulk operations PostgreSQL 14 and Recent SCRAM Authentication Changes – Should I Migrate to SCRAM? PG Phriday: Replication Engine Potpourri Accelerating VACUUM in Postgres Postgres SQL Lessons From Advent of Code Challenges Not so equal texts in PostgreSQL - and how to compare texts in a more elaborate way "Read-Only" Mode for PostgreSQL Waiting for PostgreSQL 15 – Add HEADER support to COPY text format Elevation Profiles and Flightlines with PostGIS Transaction ID and Snapshot information functions Flavio Gurgel Rubber Duck Dev S