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/
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