Episode 128 Statistics Speed Up | Synchronous Commits | TLS Updates | Avoiding Cursors

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://build.affinity.co/how-we-used-postgres-extended-statistics-to-achieve-a-3000x-speedup-ea93d3dcdc61"> https://build.affinity.co/how-we-used-postgres-extended-statistics-to-achieve-a-3000x-speedup-ea93d3dcdc61</a><br /> <br /> <a href= "https://www.percona.com/blog/2020/08/21/postgresql-synchronous_commit-options-and-synchronous-standby-replication/"> https://www.percona.com/blog/2020/08/21/postgresql-synchronous_commit-options-and-synchronous-standby-replication/</a><br /> <br /> <a href= "https://www.highgo.ca/2020/08/21/tls-related-updates-in-postgresql-13/"> https://www.highgo.ca/2020/08/21/tls-related-updates-in-postgresql-13/</a><br /> <br /> <a href= "https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-cursors-and-common-table-expressions/"> https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-cursors-and-common-table-expressions/</a><br /> <br /> <a href= "https://www.enterprisedb.com/blog/8-cool-interesting-facts-things-postgresql-can-do"> https://www.enterprisedb.com/blog/8-cool-interesting-facts-things-postgresql-can-do</a><br /> <br /> <a href= "https://www.2ndquadrant.com/en/blog/updating-the-postgresql-root-crt-file/"> https://www.2ndquadrant.com/en/blog/updating-the-postgresql-root-crt-file/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/postgresql-group-by-expression/"> https://www.cybertec-postgresql.com/en/postgresql-group-by-expression/</a><br /> <br /> <a href= "https://pganalyze.com/blog/postgres-row-level-security-django-python"> https://pganalyze.com/blog/postgres-row-level-security-django-python</a><br /> <br /> <a href= "https://www.highgo.ca/2020/08/21/how-to-setup-postgresql-on-an-ipv6-enabled-network/"> https://www.highgo.ca/2020/08/21/how-to-setu