
LZ4 & ZSTD Compression, Avoiding Problems, Triggers Simplify, Indexes Can Hurt | Scaling Postgres 263
Get New Episodes Weekly!
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.
Content Discussed
- LZ4 and ZSTD pg_dump compression in PostgreSQL 16
- Nine ways to shoot yourself in the foot with PostgreSQL
- How Postgres Triggers Can Simplify Your Backend Development
- PostgreSQL Indexes Can Hurt You: Negative Effects and the Costs Involved
- In Defense of PostgreSQL MVCC and Vacuuming
- CREATE commands in PostgreSQL releases
- PGSQL Phriday #008 — pg_stat_statements
- Logical replication permissions in PostgreSQL 15
- Waiting for Postgres 16: Running EXPLAIN on any query (even with $1 parameters!)
- Solving N+1 Postgres queries for Ruby on Rails apps
- PostgreSQL Basics: Getting started with psql
- Structured Postgres Regression Tests
- PgOSM Flex for Production OpenStreetMap data
- Queues in Postgres
- Sébastien Lardière
- All About Roda With Jeremy Evans | Rubber Duck Dev Show 83