To get the show notes as well as get notified of new episodes, visit:
[ Ссылка ]

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: [ Ссылка ]

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

свернуть