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

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://hakibenita.com/sql-for-data-analysis">https://hakibenita.com/sql-for-data-analysis</a><br /> <br /> <a href= "https://www.enterprisedb.com/postgres-tutorials/pgbouncer-setup-extended-architecture-use-cases-and-leveraging-soreuseport"> https://www.enterprisedb.com/postgres-tutorials/pgbouncer-setup-extended-architecture-use-cases-and-leveraging-soreuseport</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/postgresql-understanding-deadlocks/"> https://www.cybertec-postgresql.com/en/postgresql-understanding-deadlocks/</a><br /> <br /> <a href= "https://www.enterprisedb.com/postgres-tutorials/introduction-postgresql-performance-tuning-and-optimization"> https://www.enterprisedb.com/postgres-tutorials/introduction-postgresql-performance-tuning-and-optimization</a><br /> <br /> <a href= "https://yugonagata-pgsql.blogspot.com/2021/04/implementing-incremental-view_61.html"> https://yugonagata-pgsql.blogspot.com/2021/04/implementing-incremental-view_61.html</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/choice-of-table-column-types-and-order-when-migrating-to-postgresql"> https://blog.crunchydata.com/blog/choice-of-table-column-types-and-order-when-migrating-to-postgresql</a><br /> <br /> <a href= "https://www.migops.com/blog/2021/04/25/char1-to-boolean-datatype-transformation-while-migrating-to-postgresql/"> https://www.migops.com/blog/2021/04/25/char1-to-boolean-datatype-transformation-while-migrating-to-postgresql/</a><br /> <br /> <a href= "https://akorotkov.github.io/blog/2021/04/30/arm/">https://akorotkov.github.io/blog/2021/04/30/arm/</a><br /> <br /> <a href= "https://arctype.com/blog/postgres-set-operators/">https://arctype.com/blog/postgres-set-ope