1,400 Times Faster Max & Group By Performance

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

Listen now

Description

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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/311-max-group-by-performance/

More Episodes

See all »

Postgres Release Warning! | Scaling Postgres 343

In this episode of Scaling Postgres, we discuss new Postgres releases and an out-of-band release to address issues, increasing insert performance by 2X, pg_search benchmarks and fast OpenStreetMap loading. To get the show notes as well as get notified of new episodes,...

Published 11/24/24

Faster Writes With ZFS? | Scaling Postgres 342

In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, denormalization and a new pgvector release. To get the show notes as well as get notified of new episodes,...

Published 11/17/24

Scaling Postgres

Published 11/17/24