Episode 221 psql Shortcuts, Debugging Deadlocks, Find & Stop Queries, Using SCRAM

<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://elephas.io/psql-helper-managing-connections-and-simplifying-queries/"> https://elephas.io/psql-helper-managing-connections-and-simplifying-queries/</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/debugging-deadlocks-in-postgresql/"> https://www.cybertec-postgresql.com/en/debugging-deadlocks-in-postgresql/</a></li> <li><a href= "https://adamj.eu/tech/2022/06/20/how-to-find-and-stop-running-queries-on-postgresql/"> https://adamj.eu/tech/2022/06/20/how-to-find-and-stop-running-queries-on-postgresql/</a></li> <li><a href= "https://www.youtube.com/watch?v=whvXiAa_T6A">https://www.youtube.com/watch?v=whvXiAa_T6A</a></li> <li><a href= "https://andreas.scherbaum.la/blog/archives/1116-PostgreSQL-Upgrades-are-hard!.html"> https://andreas.scherbaum.la/blog/archives/1116-PostgreSQL-Upgrades-are-hard!.html</a></li> <li><a href= "https://fluca1978.github.io/2022/06/23/PostgreSQLOrdinality.html">https://fluca1978.github.io/2022/06/23/PostgreSQLOrdinality.html</a></li> <li><a href= "https://www.crunchydata.com/blog/indexes-selectivity-and-statistics"> https://www.crunchydata.com/blog/indexes-selectivity-and-statistics</a></li> <li><a href= "https://blog.rustprooflabs.com/2022/06/h3-indexes-on-postgis-data"> https://blog.rustprooflabs.com/2022/06/h3-indexes-on-postgis-data</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-fuzzy-text-search-case-insensitive-ICU-collations"> https://pganalyze.com/blog/5mins-postgres-fuzzy-text-search-case-insensitive-ICU-collations</a></li> <li><a href= "https://www.timescale.com/blog/how-we-made-data-aggregation-better-and-faster-on-postgresql-with-timescaledb-2-7/"> https://www.timescale.com/blog/how-we-made-data-aggregation-better-and-faster-on-postgresql-