Collation Conundrum | Scaling Postgres 307

To get the show notes as well as get notified of new episodes, visit:
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: 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

[@rosendo3219]

dude this redgate post is crazy

[@ScalingPostgres]

Yep!

[@rosendo3219]

how come percona advertise timescale? aren't they competitors?

[@ScalingPostgres]

Well, since Percona is a provider of database services and they open sourced timescale maybe Percona offers to assist customers with their timescale installation? But, I think the license might prevent directly hosting it. Not sure.