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 

 

Other Episodes

Episode 168

June 06, 2021 00:16:06
Episode Cover

Managing Autovacuum, Better JSON, Avoiding Updates, OS Tuning | Scaling Postgres 168

In this episode of Scaling Postgres, we discuss managing autovacuum, better JSON in Postgres 14, how to avoid redundant updates and operating system tuning....

Listen

Episode 273

July 10, 2023 00:15:35
Episode Cover

Debian / Ubuntu Packaging, ivfflat Indexes, In vs Any, View Logging | Scaling Postgres 273

  In this episode of Scaling Postgres, we discuss how Debian & Ubuntu package Postgres, how ifflat indexes work, in vs any performance and how...

Listen

Episode 306

March 10, 2024 00:14:29
Episode Cover

Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306

In this episode of Scaling Postgres, we discuss one configuration change that resulted in an 11,000 times faster query, why Postgres is not using...

Listen