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 193

November 28, 2021 • 00:09:26
Episode Cover

Entity-Attribute-Value Design, JSON Subscripting, mysql-fdw Push-down, New Regex | Scaling Postgres 193

In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate pushdowns and new regex...

Listen

Episode 371

June 22, 2025 • 00:21:08
Episode Cover

Are You Hurting Your Performance? | Scaling Postgres 371

In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some...

Listen

Episode 237

October 16, 2022 • 00:18:53
Episode Cover

Postgres 15 Released, File Systems, Connection Pooling, Secure Connections | Scaling Postgres 237

In this episode of Scaling Postgres, we discuss the release of Postgres 15, the performance of different file systems with Postgres, options for connection...

Listen