600 Times Faster Analytics | Scaling Postgres 396

In this episode of Scaling Postgres, we discuss using Postgres queries in ClickHouse, faster faceted search, max_connections & migrations and different scan types.

Content Discussed

• Introducing pg_clickhouse: A Postgres extension for querying ClickHouse
• 14x Faster Faceted Search in PostgreSQL with ParadeDB
• Deep Dive into ParadeDB's v2 API: The Future of SQL Search
• max_connections vs migrations
• Postgres Scan Types in EXPLAIN Plans
• PostgreSQL High-Availability Architectures
• What you should know about constraints in PostgreSQL
• PostGIS Performance: Simplification
• Building a RAG Server with PostgreSQL - Part 2: Chunking and Embeddings
• Postgres 18 New Default for Data Checksums and How to Deal with Upgrades
• The Future of the PostgreSQL Hacking Workshop
• You Gotta Push If You Wanna Pull
• pgBackRest PITR in Docker: a simple demo
• A deeper look at old UUIDv4 vs new UUIDv7 in PostgreSQL 18
• PostgreSQL, MongoDB, and what “cannot scale” really means
• PostgreSQL Contributor Story: Bryan Green
• PostGIS Day 2025 Recap: AI, Lakehouses and Geospatial Community
• Contributions for week 50, 2025
• TimescaleDB for Manufacturing IoT: Building a Data Pipeline
• Five Features of the Tiger CLI You Aren't Using (But Should)
• Realtime: Broadcast Replay
• Introducing Supabase for Platforms
• Introducing iceberg-js: A JavaScript Client for Apache Iceberg

YouTube Video

Podcast Audio