
Scaling Postgres Episode 163 SQL Data Analysis | pgBouncer Setup | Understanding Deadlocks | Tuning & Optimization
Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss doing data analysis with SQL, sophisticated pgBouncer set ups, understanding how to avoid deadlocks and an intro to tuning and optimization.
Content Discussed
- Practical SQL for Data Analysis
- pgBouncer Setup, Extended Architecture, Use-cases and leveraging SO_REUSEPORT
- PostgreSQL: Understanding deadlocks
- An Introduction to PostgreSQL Performance Tuning and Optimization
- Implementing Incremental View Maintenance for PostgreSQL (Part I)
- Choice of Table Column Types and Order When Migrating to PostgreSQL
- CHAR(1) to Boolean transformation while migrating to PostgreSQL
- Dramatical Effect of LSE Instructions for PostgreSQL on Graviton2 Instances
- Getting Started with PostgreSQL Set Operators
- Pgpool-II Logging and Debugging
- TLS: Demystifying communication encryption in PostgreSQL
- Corey Huinker