Scaling Postgres

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