Episode 222 Postgres 15 Beta 2, Concerning Locks, Vacuum Tuning, Transaction Anomalies
Scaling Postgres
English - July 04, 2022 13:41 - 17 minutes - 24.4 MB - ★★★★★ - 9 ratingsTechnology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
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/