Scaling Postgres Episode 171 Practical Partitioning | Understanding pg_repack | Explaining Buffers | Multi-row Contraints

In this episode of Scaling Postgres, we discuss practical partitioning, understanding pg_repack, explaining buffers and enforcing multi-row constraints.

Content Discussed

• PostgreSQL 14 Beta 2 Released!
• Postgres Vision 2021
• Practical Partitioning in Production with Postgres [Postgres Vision 2021]
• Understanding pg_repack: What Can Go Wrong – and How to Avoid It
• Explaining the unexplainable – part 6: buffers
• PostgreSQL: Constraints over multiple rows
• From MD5 to scram-sha-256 in PostgreSQL
• A tale of making company-wide standard psqlrc
• Zero-downtime schema migrations in Postgres using views
• Using GeoDjango and PostGIS in Django
• Federico Campoli
• Rubber Duck Dev Show Episode 1 | It's All About The Tests!