Radio and PodcastLive Radio & PodcastsOpening Radio and Podcast...
Radio and PodcastLive Radio & PodcastsFetching podcast shows and categories...
Radio and PodcastLive Radio & PodcastsFetching podcast episodes...
Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for d...
In this episode of Scaling Postgres, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcin...
In this episode of Scaling Postgres, we discuss sharding your database with one command, more information about the Linux 7 Postgres perform...
In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is missing i...
In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CT...
In this episode of Scaling Postgres, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrad...
In this episode of Scaling Postgres, we discuss how Apache Iceberg may have lead to Postgres company acquisitions, presentations on CloudNat...
In this episode of Scaling Postgres, we discuss how open source is eating the world, mitigating plan flips, migrating from Heroku to RDS, an...
In this episode of Scaling Postgres, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or cras...
In this episode of Scaling Postgres, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and...
In this episode of Scaling Postgres, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and...
In this episode of Scaling Postgres, we discuss how the postmaster does not scale, new Postgres releases, data storage using PAX and a path...
In this episode of Scaling Postgres, we discuss a potential way to mitigate retry storms or orphan DB sessions with client_connection_check_...
In this episode of Scaling Postgres, we discuss how OpenAI's ChatGPT handles millions of queries per second, an update on PgDog, Clickhouse...
In this episode of Scaling Postgres, we discuss searching one billion vectors on Postgres, how to bypass a vector index search, unconvention...
In this episode of Scaling Postgres, we discuss the cost of arrays, dealing with integer overflow, idle sessions causing transaction wraparo...
In this episode of Scaling Postgres, we discuss the overhead of indexes, a Postgres year in review, an intro to row locking and table renami...
In this episode of Scaling Postgres, we examine how latency impacts performance, naughty queries, bm25 indexes and how to quickly create dat...
In this episode of Scaling Postgres, we discuss if vacuum is lying to you with regard to index cleanup, an agentic toolkit with MCP server,...
In this episode of Scaling Postgres, we discuss using Postgres queries in ClickHouse, faster faceted search, max_connections & migrations an...
In this episode of Scaling Postgres, we discuss a patch that can plan joins 16 times faster, the best way to record text values, extensions...
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres...
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres...
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal...
In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importa...
In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and...
In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information ab...
In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and...
In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budge...
In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with l...
In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced r...
In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a...
In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and...
In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary...
In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS...
In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework...
In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top...
In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling list...
In this episode of Scaling Postgres, we discuss how to shard your DB at network speeds, how to make your DB 42,000 slower, new monitoring an...
In this episode of Scaling Postgres, we discuss a 100K events per second queue built on Postgres, how an MCP can leak your database, MultiXa...
In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improv...
In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector...
In this episode of Scaling Postgres, we discuss the release of Planetscale Postgres and the advantages for bare metal, how often queries are...
In this episode of Scaling Postgres, we discuss some possible futures for Postgres architectures, choosing a multi-tenancy model, vectors in...
In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads...
In this episode of Scaling Postgres, we discuss the start of Multigres which is a Vitess for Postgres, pgactive going open source, getting s...
In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQ...
In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres...
In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of fi...
In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres...
In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovativ...