1,400 Times Faster Max & Group By Performance | Scaling Postgres 311
Join Over 1,000 Engineers & Get New Episodes Weekly!
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
