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

Episode 252 • February 12, 2023 • 00:14:56
Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252
Scaling Postgres
Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252

Feb 12 2023 | 00:14:56

/

Hosted By

Creston Jamison

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 

 

Previous Episode
Next Episode

Other Episodes

Episode 216

May 22, 2022 • 00:13:50
Episode Cover

PG 15 Beta 1 Release, Query Breakdown, Sort Performance, Prepared vs. Partitioned | Scaling Postgres 216

In this episode of Scaling Postgres, we discuss the Beta 1 release of Postgres 15, optimizing a query by breaking it down, improvements to...

Listen

Episode 164

May 09, 2021 • 00:17:29
Episode Cover

Fast Random Rows, Fast Distinct Queries, Temp & Unlogged Tables, Terminating Connections | Scaling Postgres 164

In this episode of Scaling Postgres, we discuss selecting random rows quickly, faster distinct queries, how replication handles temp and unlogged tables and how...

Listen

Episode 191

November 15, 2021 • 00:14:54
Episode Cover

Man-In-The-Middle, pg_auto_failover, Lesser Known Features, LZ4 Compression | Scaling Postgres 191

In this episode of Scaling Postgres, we discuss new releases of Postgres due to a man-in-the-middle vulnerability, the high availability solution pg_auto_failover, lesser known...

Listen