LZ4 & ZSTD Compression, Avoiding Problems, Triggers Simplify, Indexes Can Hurt

Scaling Postgres

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

May 01 2023 | 00:19:14

00:00 / 00:19:14

Hosted By

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/

Other Episodes

Episode 243

November 27, 2022 • 00:10:25

IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest | Scaling Postgres 243

In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS...

Episode 387

October 12, 2025 • 00:15:54

Boosting Planning Performance | Scaling Postgres 387

In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget,...

Episode 303

February 18, 2024 • 00:19:55

PgBouncer, PgCat, Supavisor Fight!!! | Scaling Postgres 303

In this episode of Scaling Postgres, we discuss new Postgres releases, performance comparisons between PgBouncer, PgCat and Supavisor, a new extension pg_analytics, and new...