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

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/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. Want to learn more about Postgres performance? Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/courses/postgresql-performance-starter-kit/ Timestamps: 00:00 - Intro 00:30 - Practical SQL for Data Analysis 03:04 - pgBouncer Setup, Extended Architecture, Use-cases and leveraging SO_REUSEPORT 05:51 - PostgreSQL: Understanding deadlocks 08:25 - An Introduction to PostgreSQL Performance Tuning and Optimization 09:06 - Implementing Incremental View Maintenance for PostgreSQL (Part I) 10:37 - Choice of Table Column Types and Order When Migrating to PostgreSQL 12:01 - CHAR(1) to Boolean transformation while migrating to PostgreSQL 12:41 - Dramatical Effect of LSE Instructions for PostgreSQL on Graviton2 Instances 13:58 - Getting Started with PostgreSQL Set Operators 14:32 - Pgpool-II Logging and Debugging 14:45 - TLS: Demystifying communication encryption in PostgreSQL 15:06 - Corey Huinker 15:18 - Outro #postgres #postgresql