Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case

Scaling Postgres

Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252

Feb 12 2023 | 00:14:56

00:00 / 00:14:56

Hosted By

Show Notes

In this episode of Scaling Postgres, we discuss new Postgres releases, performance secrets, things not to do and filter vs. case.

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

https://www.scalingpostgres.com

Other Episodes

Episode 137

October 26, 2020 • 00:21:14

Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137

In this episode of Scaling Postgres, we discuss the impact of toast, zheap storage results, more Postgres 13 performance data and changes to pg_rewind....

Episode 256

March 12, 2023 • 00:12:23

11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256

In this episode of Scaling Postgres, we discuss WAL growing to 11 Terabytes, pgec supporting writes, Patroni 3.0 & Citus for high availability, and...

Episode 276

July 30, 2023 • 00:15:57

BRIN & Correlation, Poor Partitioning, 10 Beginner Tips, Table & Index Usage | Scaling Postgres 276

In this episode of Scaling Postgres, we discuss the importance of correlation with BRIN indexes, how partitioning can kill performance, 10 tips for beginners...