1,400 Times Faster Max & Group By Performance

1,400 Times Faster Max & Group By Performance | Scaling Postgres 311

Рет қаралды 1,047

Күн бұрын

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 a 1,400 times faster max and group by implementation, new quantization capabilities in pgvector, adaptive radix trees and splitting & merging partitions in PG17.
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:40 - Performance tuning: MAX and GROUP BY
04:13 - Scalar and binary quantization for pgvector vector search and storage
10:32 - Waiting for Postgres 17: Faster VACUUM with Adaptive Radix Trees
13:27 - PostgreSQL 17: Split and Merge partitions
15:06 - Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2
16:01 - Protect Your PostgreSQL Database with pg_tde: Safe and Secure
16:41 - Building the Best PostgreSQL GUI: Announcing Our Acquisition of PopSQL
17:46 - Don't do this
18:24 - Outro
#postgres #postgresql

Пікірлер: 7

@jocketf3083 3 ай бұрын

Thank you for another great episode!

@ScalingPostgres 3 ай бұрын

Thanks!

@rosendo3219 3 ай бұрын

macos compilation post is super useful. huge thanks Creston!

@ScalingPostgres 3 ай бұрын

Haha, I just report on the content. The kudos definitely goes to Andrew.

@rosendo3219 3 ай бұрын

omg redgate part 2 released

@ScalingPostgres 3 ай бұрын

Yep!

@utenatenjou2139 3 ай бұрын

Interesting, these type of aggregate for each, with extremely large scale, I may design partition (hash) on the id. I don't know how parallelism will do in postgres, I might try that., 14:56 merge/split is nice but lock, reduce the real world implementation, hope there are patch on it. 16:38, totally agree, with the rise of DPO data protection officer, and its regulation requirement, database layer encryption become a hurdle to pick PostgreSQL, there are time that mysql win because of the burden to get security exemption needed to do on postgres.