Creston Jamison

Scaling Postgres 410 is released! In this episode, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrades, a DB schema migration survey and a new repack command: scalingpostgres.com/episodes/410-p… #Postgres #PostgreSQL

Scaling Postgres 409 is released! In this episode, we discuss how Apache Iceberg may have lead to Postgres company acquisitions, presentations on CloudNativePG & query tuning, setting up Patroni and utilizing PgBouncer: scalingpostgres.com/episodes/409-i… #Postgres #PostgreSQL

Scaling Postgres 408 is released! In this episode, we discuss how open source is eating the world, mitigating plan flips, migrating from Heroku to RDS, and how work_mem is a trap: scalingpostgres.com/episodes/408-o… #Postgres #PostgreSQL

Scaling Postgres 407 is released! In this episode, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or crashed clients, on conflict do select and all about Patroni: scalingpostgres.com/episodes/407-s… #Postgres #PostgreSQL

Scaling Postgres 406 is released! In this episode, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and pg_ash for wait sampling: scalingpostgres.com/episodes/406-l… #Postgres #PostgreSQL

Scaling Postgres 405 is released! In this episode, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and how to maintain reading efficiency: scalingpostgres.com/episodes/405-o… #Postgres #PostgreSQL

Scaling Postgres 404 is released! In this episode, we discuss how the postmaster does not scale, new Postgres releases, data storage using PAX and a path generation strategies change: scalingpostgres.com/episodes/404-p… #Postgres #PostgreSQL

Scaling Postgres 403 is released! In this episode, we discuss a potential way to mitigate retry storms or orphan DB sessions with client_connection_check_interval, checkpoint configuration, skip scans and more just use Postgres: scalingpostgres.com/episodes/403-m… #Postgres #PostgreSQL

Scaling Postgres 402 is released! In this episode, we discuss how OpenAI's ChatGPT handles millions of queries per second, an update on PgDog, Clickhouse offers OLTP hosted Postgres and partition table source of truth: scalingpostgres.com/episodes/402-m… #Postgres #PostgreSQL

@mhmazur Keep chugging after 8 years, hehe.

@CrestonJamison Glad to see you're still doing these!

Scaling Postgres 401 is released! In this episode, we discuss searching one billion vectors on Postgres, how to bypass a vector index search, unconventional optimizations and a 40x boost to listen/notify performance: scalingpostgres.com/episodes/401-o… #Postgres #PostgreSQL

Scaling Postgres 400 is released! In this episode, we discuss the cost of arrays, dealing with integer overflow, idle sessions causing transaction wraparound and AI or LLM index recommendations: scalingpostgres.com/episodes/400-t… #Postgres #PostgreSQL

Scaling Postgres 399 is released! In this episode, we discuss the overhead of indexes, a Postgres year in review, an intro to row locking and table renaming issues: scalingpostgres.com/episodes/399-i… #Postgres #PostgreSQL

Scaling Postgres Episode 398 is released! In this episode, we examine how latency impacts performance, naughty queries, bm25 indexes and how to quickly create database clones: scalingpostgres.com/episodes/398-l… #Postgres #PostgreSQL

Scaling Postgres Episode 397 is released! In this episode, we discuss if vacuum is lying to you with regard to index cleanup, an agentic toolkit with MCP server, indexes getting corrupted after an upgrade and $50 Planetscale Metal: scalingpostgres.com/episodes/397-v… #Postgres #PostgreSQL

Scaling Postgres Episode 396 is released! In this episode, we discuss using Postgres queries in ClickHouse, faster faceted search, max_connections & migrations and different scan types: scalingpostgres.com/episodes/396-6… #Postgres #PostgreSQL

Scaling Postgres Episode 395 is released! In this episode, we discuss a patch that can plan joins 16 times faster, the best way to record text values, extensions via image volumes with CloudNativePG and using pg_partman vs rolling your own: scalingpostgres.com/episodes/395-1… #Postgres #PostgreSQL

Scaling Postgres Episode 394 is released! In this episode, we discuss enhancements bringing more than five times faster aggregates and 64% faster counts, better performance through sampling and my course sale is ending: scalingpostgres.com/episodes/394-f… #Postgres #PostgreSQL

Scaling Postgres Episode 393 is released! In this episode, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should hard your database: scalingpostgres.com/episodes/393-j… #Postgres #PostgreSQL

Scaling Postgres 392 is released! In this episode, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my upcoming course discount: scalingpostgres.com/episodes/392-1… #Postgres #PostgreSQL