Scaling Postgres

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