Scaling Postgres Episode 154 Connection Queuing | Connection Pool Size | Simple Audting | Fuzzy Matching

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.

Content Discussed

• Connection Queuing in pgBouncer: Is it a Magical Remedy?
• Estimating connection pool size with PostgreSQL database statistics
• Simply auditing your database changes
• Fuzzy Name Matching in Postgres
• PostgreSQL: How to write a trigger
• PostgreSQL Logical Replication Advantage and Step by Step Setup
• Faster data migrations in Postgres
• First Review of Partitioning OpenStreetMap
• Round Two: Partitioning OpenStreetMap
• Takayuki Tsunakawa

YouTube Video