300 Times Faster Analytics With pgrust | Scaling Postgres 429

In this episode of Scaling Postgres, we discuss pgrust running analytical queries 300 times faster than Postgres, how to speed up distinct count, Xata podcast and massively parallel backups.

Content Discussed

• Rebuilding Postgres for 300x faster analytics: batching, operator fusion, and SIMD
• Your COUNT(DISTINCT) Is Too Slow: Approximations and Sampling in Postgres
• The DISTINCT in your COUNT
• Xata
• Massively parallel Postgres backups
• Turning Claude into Postgres so I can raise a Series A
• Ontogeny Recapitulates the Relcache
• Hacking Workshop for September 2026
• [YouTube] PGConf.dev 2026
• Tuning PostgreSQL HOT Updates - A HammerDB Benchmark
• PostgreSQL Snapshot Backup and Restore with Proxmox ZFS (4/4)
• TDE performance in PostgreSQL
• PostgreSQL Lockup vs Stale Connection: How to Tell Them Apart
• Mastering PostgreSQL Configuration Management with CloudNativePG (CNPG)
• PostgreSQL 18's extension_control_path: Decoupling Extensions from Server Images
• CNPG Recipe 26 - Extension image catalogs
• A 13-year-old PostgreSQL bug, found by running Postgres on Kubernetes with CloudNativePG
• Looking Forward to Postgres 19: The Cult of Functionality
• Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ)
• Performance Farm July 2026 Update
• ORBIT: An Execution Framework for Reliable Enterprise AI
• WAWTech+Summer 2026 [UNLOGGED]
• CYBERTEC and Meniko Data Solutions Announce Strategic Partnership
• Postgres Changes gets AND filters, new operators, and column selection
• Introducing Supabase Evals
• Neon now has per-project permissions
• Agents Are a Data Problem — and EDB Postgres® AI Just Became the Answer
• The Canvas or the Function: AIDB vs. Langflow for Agentic AI Ops on EDB Postgres AI

YouTube Video

Podcast Audio