Scaling Postgres

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-set