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 274

July 16, 2023 • 00:14:40

Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274

In this episode of Scaling Postgres, we discuss subquery performance, how to avoid excessive locking when doing updates, how to change a columns datatype...

Episode 230

August 28, 2022 • 00:12:33

Stats Collector Gone, Handling Latency, PG In The Browser, Future High Availability | Scaling Postgres 230

In this episode of Scaling Postgres, we discuss how the stats collector disappears in PG15, steps to mitigate high latency connections, how to run...

Episode 344

December 01, 2024 • 00:17:38

Performance & Hard Things | Scaling Postgres 344

In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance. To get the...