LZ4 & ZSTD Compression, Avoiding Problems, Triggers Simplify, Indexes Can Hurt | Scaling Postgres 263

Episode 263 • May 01, 2023 • 00:19:14
LZ4 & ZSTD Compression, Avoiding Problems, Triggers Simplify, Indexes Can Hurt | Scaling Postgres 263
Scaling Postgres
LZ4 & ZSTD Compression, Avoiding Problems, Triggers Simplify, Indexes Can Hurt | Scaling Postgres 263

May 01 2023 | 00:19:14

/

Hosted By

Creston Jamison

Show Notes

 

In this episode of Scaling Postgres, we discuss LZ4 and ZSTD pg_dump compression, how to avoid problems, can triggers simplify and indexes can hurt.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/263-lz4-zstd-compression-avoiding-problems-triggers-simplify-indexes-can-hurt/

Previous Episode
Next Episode

Other Episodes

Episode 418

May 24, 2026 • 00:16:51
Episode Cover

Multigres Architecture | Scaling Postgres 418

In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations. To...

Listen

Episode 178

August 16, 2021 • 00:15:11
Episode Cover

Postgres Releases, Performance Discussion, Index Types, Index Power Use | Scaling Postgres 178

In this episode of Scaling Postgres, we discuss new releases for Postgres & pgbouncer, have a performance discussion, describe the different index types and...

Listen

Episode 170

June 20, 2021 • 00:15:08
Episode Cover

Redis vs Postgres, Hard Quadrant, Optimizing Joins, Materialized Views | Scaling Postgres 170

In this episode of Scaling Postgres, we discuss Redis vs. Postgres, working in the hard quadrant, how Postgres optimizes joins and working with materialized...

Listen