Collation Conundrum | Scaling Postgres 307
Listen now
Description
In this episode of Scaling Postgres, we discuss whether we should be using bytewise or linguistic ordering by default, how to transform data in Postgres, benefits of a transaction_timeout and how to enforce join order. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/307-collation-conundrum/  
More Episodes
In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, denormalization and a new pgvector release. To get the show notes as well as get notified of new episodes,...
Published 11/17/24
In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and limitless Aurora. To get the show notes as well as get notified of new episodes,...
Published 11/10/24
Published 11/10/24