In this episode of Scaling Postgres, we discuss connection queuing, estimating connection pools size, how to do simple auditing and how to run queries using fuzzy matching.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:
https://www.percona.com/blog/2021/02/26/connection-queuing-in-pgbouncer-is-it-a-magical-remedy/

https://www.cybertec-postgresql.com/en/estimating-connection-pool-size-with-postgresql-database-statistics/

https://mydbanotebook.org/post/auditing/

https://info.crunchydata.com/blog/fuzzy-name-matching-in-postgresql

https://www.cybertec-postgresql.com/en/postgresql-how-to-write-a-trigger/

https://www.highgo.ca/2021/02/24/postgresql-logical-replication-advantage-and-step-by-step-set-up/

https://www.citusdata.com/blog/2021/02/20/faster-data-migrations-in-postgres/

https://blog.rustprooflabs.com/2021/02/postgres-partition-openstreetmap-road-v1-review

https://blog.rustprooflabs.com/2021/02/postgres-partition-openstreetmap-road-v2-review

https://postgresql.life/post/takayuki_tsunakawa/