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

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.

Content Discussed

• Performance tuning: MAX and GROUP BY
• Scalar and binary quantization for pgvector vector search and storage
• Waiting for Postgres 17: Faster VACUUM with Adaptive Radix Trees
• PostgreSQL 17: Split and Merge partitions
• Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2
• Protect Your PostgreSQL Database with pg_tde: Safe and Secure
• Building the Best PostgreSQL GUI: Announcing Our Acquisition of PopSQL
• PostgreSQL 17: Add allow_alter_system GUC
• CloudNativePG Recipe 6: Postgres Vertical Scaling with Storage - part 1
• Don't do this
• Compiling PostgreSQL on macOS To Test Documentation and Patches
• PG Phriday: Wanton Animal Cruelty
• Becoming expert at using PostgreSQL with Chris Ellis
• PgBouncer Connection Pooler for Postgres Now Supports More Session Vars
• PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables.
• Jonah H. Harris
• A day in the life of a Postgres engineer at Fujitsu - Hayato Kuroda
• PostgreSQL Roles and Privileges Simplified
• PostgreSQL Stories: A simple query with a big problem
• Features I wish PostgreSQL had as a developer
• Time-Series Forecasting With TimescaleDB and Prophet

YouTube Video

Podcast Audio