Statistics Speed Up, Synchronous Commits, TLS Updates, Avoiding Cursors | Scaling Postgres 128
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/
Create your
podcast in
minutes
It is Free