Collation Conundrum | Scaling Postgres 307

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

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.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:26 - Using binary-sorted indexes
06:50 - Transforming and Analyzing Data in PostgreSQL
08:40 - transaction_timeout
10:08 - Enforcing join orders in PostgreSQL
11:42 - Speed up PostgreSQL® pgvector queries with indexes
12:11 - How to use pgbench to test PostgreSQL® performance
12:27 - Trying Out CloudNative-PG: A Novice in a Kubernetes World
12:56 - CloudNativePG Recipe 2 - Inspecting Default Resources in a CloudNativePG Cluster
13:08 - CloudNativePG Recipe 3 - What!?! No superuser access?
13:31 - Managing Time Series Data Using TimeScaleDB-Powered PostgreSQL
13:55 - Outro

#postgres #postgresql