Search


	Podcast:		Scaling Postgres
	Episode:		Episode 221 psql Shortcuts, Debugging Deadlocks, Find & Stop Queries, Using SCRAM
	Category:		Technology
	Duration:		00:17:36
	Publish Date:		2022-06-27 13:31:00
	Description:		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/
	Total Play:		0