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