Search


	Podcast:		Scaling Postgres
	Episode:		Episode 163 SQL Data Analysis \| pgBouncer Setup \| Understanding Deadlocks \| Tuning & Optimization
	Category:		Technology
	Duration:		00:15:43
	Publish Date:		2021-05-02 21:13:38
	Description:		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/
	Total Play:		0