
Scaling Postgres Episode 221 psql Shortcuts, Debugging Deadlocks, Find & Stop Queries, Using SCRAM
Get New Episodes Weekly!
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.
Content Discussed
- PSQL Helper: Managing Connections and Simplifying Queries
- Debugging deadlocks in PostgreSQL
- How to Find and Stop Running Queries on PostgreSQL
- [YouTube] Get Your Insecure PostgreSQL Passwords to SCRAM!
- PostgreSQL Upgrades are hard!
- Ordinality in fuction queries
- Postgres Indexes, Selectivity, and Statistics
- H3 indexes for performance with PostGIS data
- 5mins of Postgres E23: Fuzzy text search & case-insensitive ICU collations in Postgres
- How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7
- Hervé Schweitzer
- Rubber Duck Dev Show Episode 47 | Ruby 3 Keyword Arguments