Episode 222 Postgres 15 Beta 2, Concerning Locks, Vacuum Tuning, Transaction Anomalies

<p>In this episode of Scaling Postgres, we discuss psql shortcuts, how to debug deadlocks, how to find & stop queries and how to understand and use SCRAM authentication.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.postgresql.org/about/news/postgresql-15-beta-2-released-2479/"> https://www.postgresql.org/about/news/postgresql-15-beta-2-released-2479/</a></li> <li><a href= "https://www.crunchydata.com/blog/postgres-locking-when-is-it-concerning"> https://www.crunchydata.com/blog/postgres-locking-when-is-it-concerning</a></li> <li><a href= "https://www.percona.com/blog/importance-of-postgresql-vacuum-tuning-and-custom-scheduled-vacuum-job/"> https://www.percona.com/blog/importance-of-postgresql-vacuum-tuning-and-custom-scheduled-vacuum-job/</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/transaction-anomalies-with-select-for-update/"> https://www.cybertec-postgresql.com/en/transaction-anomalies-with-select-for-update/</a></li> <li><a href= "https://andreas.scherbaum.la/blog/archives/1117-ctid-and-other-PostgreSQL-table-internals.html"> https://andreas.scherbaum.la/blog/archives/1117-ctid-and-other-PostgreSQL-table-internals.html</a></li> <li><a href= "https://www.postgresql.fastware.com/blog/introducing-publication-row-filters"> https://www.postgresql.fastware.com/blog/introducing-publication-row-filters</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-tuning-statistics-target-selectivity-spatial-indexes"> https://pganalyze.com/blog/5mins-postgres-tuning-statistics-target-selectivity-spatial-indexes</a></li> <li><a href= "https://andreas.scherbaum.la/blog/archives/1118-2-+-2-4-16.html">https://andreas.scherbaum.la/blog/archives/1118-2-+-2-4-16.html</a></li> <li><a href= "https://supabase.com/blog/2022/06/28/partial-postgresql-data-dumps-with-rls"> https://supabase.com/blog/2022/06/28/partial-postgresql-data-dumps-with-rls</a></li> <li><a href= "https://cloud.google.com/blog/product