Scaling Postgres Episode 163 SQL Data Analysis | pgBouncer Setup | Understanding Deadlocks | Tuning & Optimization

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