Postgres 16 Beta 2, The Rise of Vectors, FDW Performance, Unused Indexes

Scaling Postgres

Postgres 16 Beta 2, The Rise of Vectors, FDW Performance, Unused Indexes | Scaling Postgres 272

Jul 03 2023 | 00:14:39

00:00 / 00:14:39

Hosted By

Show Notes

In this episode of Scaling Postgres, we discuss the release of Postgres 16 Beta 2, the rise of vectors and storing them, Foreign Data Wrapper performance and how to identify unused indexes.

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

https://www.scalingpostgres.com/episodes/272-postgres-16-beta-2-rise-of-vectors-fdw-performance-unused-indexes/

Other Episodes

Episode 206

March 13, 2022 • 00:17:51

100x Optimizations, Auditing, Document Schema Designs, Checksums | Scaling Postgres 206

In this episode of Scaling Postgres, we discuss 100x optimizations, how to audit table activity, designing schemas and how to set up table checksums....

Episode 238

October 24, 2022 • 00:13:05

Slow Updates, Lateral Joins, Serial To Identity, PG 15 Changes | Scaling Postgres 238

In this episode of Scaling Postgres, we discuss why and what to do when updates are slow, use cases for lateral joins, moving from...

Episode 271

June 26, 2023 • 00:16:24

30% Faster, UUID Downsides, Growing WAL, Processes vs. Threads | Scaling Postgres 271

In this episode of Scaling Postgres, we discuss how to get 30% faster performance, the downsides of UUIDs, having too much WAL and whether...