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://www.postgresql.org/about/news/postgresql-15-beta-2-released-2479/
• https://www.crunchydata.com/blog/postgres-locking-when-is-it-concerning
• https://www.percona.com/blog/importance-of-postgresql-vacuum-tuning-and-custom-scheduled-vacuum-job/
• https://www.cybertec-postgresql.com/en/transaction-anomalies-with-select-for-update/
• https://andreas.scherbaum.la/blog/archives/1117-ctid-and-other-PostgreSQL-table-internals.html
• https://www.postgresql.fastware.com/blog/introducing-publication-row-filters
• https://pganalyze.com/blog/5mins-postgres-tuning-statistics-target-selectivity-spatial-indexes
• https://andreas.scherbaum.la/blog/archives/1118-2-+-2-4-16.html
• https://supabase.com/blog/2022/06/28/partial-postgresql-data-dumps-with-rls
• https://cloud.google.com/blog/products/databases/postgresql-interface-for-spanner-now-ga
• https://www.timescale.com/blog/sql-isnt-that-hard-when-you-dont-approach-it-from-an-object-oriented-point-of-view/
• https://www.timescale.com/blog/sql-isnt-that-hard-if-you-have-the-freedom-to-experiment/
• https://postgresql.life/post/mladen_marinovic/
• https://www.rubberduckdevshow.com/episodes/48-ruby-fibers/