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://arctype.com/blog/postgres-set-operators/

https://b-peng.blogspot.com/2021/04/pgpool-logging-debugging.html

https://www.cybertec-postgresql.com/en/tls-demystifying-communication-encryption-in-postgresql/

https://postgresql.life/post/corey_huinker/