Scaling Postgres Episode 129 28 Tips | Lucky 13 | Autovacuum Tuning | Logical Pitfalls

In this episode of Scaling Postgres, we discuss 28 tips & tricks, Postgres 13 is lucky, autovacuum tuning and logical replication pitfalls.

Content Discussed

• Postgres Tips And Tricks
• Why PostgreSQL 13 is a Lucky Release
• Tuning PostgreSQL autovacuum
• Pitfalls and quirks of logical replication in Postgres 12
• [YouTube] Webinar: Business Intelligence with Window Functions in PostgreSQL by Gianni Ciolli
• Authentication in Pgpool-II
• Introducing the Postgres Prometheus Adapter
• Who is spending wal crazily
• Advanced partition matching for partition-wise join
• Waiting for PostgreSQL 14 – pg_stat_statements: track number of rows processed by some utility commands.
• Preventing SQL Injection Attacks in Postgres
• Renee Phillips

YouTube Video