Scaling Postgres Episode 130 External Compression | Parallel Vacuum | JSON Aggregates | JSON & Arrays

In this episode of Scaling Postgres, we discuss external compression, vacuuming in parallel, working with JSON Aggregates and the JSON & Array datatypes.

Content Discussed

Need for external compression methods in PostgreSQL
Parallelism comes to VACUUM
Postgres json aggregate functions are pretty cool
Webinar: JSON & ARRAY – Contemporary PostgreSQL Data Types [Follow Up]
How to Get the Best Out of PostgreSQL Logs
PostgreSQL vs PostGreSQL vs Postgre vs Oracle vs all the rest
Oracle to PostgreSQL — Cursors and ltrees
Three Easy Things To Remember About Postgres Indexes
An Overview of Trusted Extensions in PostgreSQL 13
PostgreSQL Backups
Combining pgBackRest and Streaming Replication, PG13 update
Marco Slot