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

YouTube Video