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-postgresql-with-timescaledb-2-7/
- https://postgresql.life/post/herve_schweitzer/
- https://www.rubberduckdevshow.com/episodes/47-ruby-3-keyword-arguments/