Search


	Podcast:		Scaling Postgres
	Episode:		Episode 128 Statistics Speed Up \| Synchronous Commits \| TLS Updates \| Avoiding Cursors
	Category:		Technology
	Duration:		00:16:57
	Publish Date:		2020-08-24 00:09:46
	Description:		In this episode of Scaling Postgres, we discuss speeding up performance with statistics, setting synchronous_commit, updates to TLS settings and how to avoid cursors. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://build.affinity.co/how-we-used-postgres-extended-statistics-to-achieve-a-3000x-speedup-ea93d3dcdc61 https://www.percona.com/blog/2020/08/21/postgresql-synchronous_commit-options-and-synchronous-standby-replication/ https://www.highgo.ca/2020/08/21/tls-related-updates-in-postgresql-13/ https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-cursors-and-common-table-expressions/ https://www.enterprisedb.com/blog/8-cool-interesting-facts-things-postgresql-can-do https://www.2ndquadrant.com/en/blog/updating-the-postgresql-root-crt-file/ https://www.cybertec-postgresql.com/en/postgresql-group-by-expression/ https://pganalyze.com/blog/postgres-row-level-security-django-python https://www.highgo.ca/2020/08/21/how-to-setup-postgresql-on-an-ipv6-enabled-network/ https://www.2ndquadrant.com/en/blog/webinar-similarity-queries-in-postgresql-follow-up/ https://postgresql.life/post/charles_clavadetscher/
	Total Play:		0