Search a title or topic

Over 20 million podcasts, powered by 

Player FM logo

PostgreSQL Podcasts

show episodes
 
Artwork

1
Scaling Postgres

Creston Jamison

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Weekly
 
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 developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.
  continue reading
 
Talking Postgres is a podcast for developers who love Postgres. Guests join Claire Giordano each month to discuss the human side of PostgreSQL, databases, and open source. With amazing guests such as Boriss Mejías, Melanie Plageman, Tom Lane, Simon Willison, Robert Haas, and Andres Freund, Talking Postgres is guaranteed to get you thinking. Recorded live on Discord by the Postgres team at Microsoft, you can subscribe to our calendar to join us live on the parallel text chat (which is quite f ...
  continue reading
 
Artwork

1
Data in the Wild

Queen Raae

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Monthly+
 
Learn from your favorite indie hackers as they share hard-earned lessons and tall tales from their data model journeys! Brought to you by Xata — the only serverless data platform for PostgreSQL.
  continue reading
 
Artwork

1
Azure Friday

Scott Hanselman

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Monthly
 
Join Scott Hanselman every Friday as he engages one-on-one with the engineers who build the services that power Microsoft Azure as they demo capabilities, answer Scott's questions, and share their insights. Follow us at: friday.azure.com.
  continue reading
 
Artwork

1
Programmers Quickie

Software Engineering

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Weekly
 
Software Engineering Best Practices, System Design, High Scale, Algorithms, Math, Programming Languages, Statistics, Machine Learning, Databases, Front Ends, Frameworks, Low Level Machine Structure, Papers and Computing, Computer Science Book Reviews - Everything!
  continue reading
 
Artwork

1
The Binary Breakdown

The Binary Breakdown

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Weekly
 
Binary Breakdown is your go-to podcast for exploring the latest in computer science research and technology. Each episode dives into groundbreaking papers, emerging technologies, and the ideas shaping our digital world. Whether you're a tech enthusiast, a computer science student, or a seasoned professional, Binary Breakdown decodes complex topics into insightful discussions, connecting the dots between theory and real-world application. Join us as we break down binary, byte by byte, to unco ...
  continue reading
 
Loading …
show series
 
Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18. Here are some links to things they mentioned: EXPLAIN (official docs) https://www.postgresql.org/docs/current/sql-explain.html Using EXPLAIN (official docs) https://www.postgresql.org/docs/current/using-explain.html EXPLAIN glossary (pgMustard site) https://www.pgmu…
  continue reading
 
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my upcoming course discount. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/392-100-times-faster-by-skipping/ Want…
  continue reading
 
Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. Here are some links to things they mentioned: Ultra-fast replica creation with pgBackRest (blog post by Maxim Boguk and Nik) https://postgres.ai/blog/20251105-postgres-marathon-2-012-ultra-fast-replica-creation-pgbackrest C…
  continue reading
 
In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of a txvector column and an upcoming sale on my course. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/391-table-lock-explosion/ Want to learn…
  continue reading
 
What do guitar busking, geospatial queries, and agentic coding have to do with Postgres? In Episode 33 of Talking Postgres, principal engineer Rob Emanuele at Microsoft shares his winding path from Venice Beach to building a new VS Code extension for PostgreSQL—that works with any Postgres, anywhere. We dig into GitHub Copilot, ask vs. agent mode, …
  continue reading
 
This week on Azure Friday, we explore how Azure Logic Apps enables developers to build autonomous and conversational agentic workflows. The episode dives into how Agent Loop brings intelligence into workflows, supports multi-agent patterns, and makes it easy to connect agents, people, and enterprise systems — all on a secure, enterprise-ready platf…
  continue reading
 
See Azure SRE Agent transform your DevOps workflow from reactive firefighting to proactive reliability engineering. This demo showcases end-to-end incident management with ServiceNow integration, custom runbook automation, and intelligent source code analysis. Watch as incidents automatically trigger diagnosis, mitigation, root cause analysis, crea…
  continue reading
 
In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/390-1.2-million-messages-per-second/ Want to learn more about Postgres perfor…
  continue reading
 
Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them. And one quick clarification: changing the CACHE option in CREATE SEQUENCE can lead to even more gaps, the docs mention it explicitly. Here are some links to things they mentioned: CREAT…
  continue reading
 
In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/389-heavy-reader-or-writer/ Want to…
  continue reading
 
This week on Azure Friday, Scott Hanselman meets with Jordan Selig to learn about resiliency on Azure App Service and discover how quick and easy it is to add intelligent, connected agents to new and existing Azure App Service apps. Chapters 00:00 - Introduction 01:14 - Zone redundancy on Azure App Service 04:24 - Add agents to your apps 08:17 - De…
  continue reading
 
In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems? To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/388-nvme-wins/ Want to le…
  continue reading
 
Nik and Michael discuss lightweight locks in Postgres — how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues. Here are some links to things they mentioned: Wait Events of Type LWLock https://www.postgresql.org/docs/current/monitoring-stats.html#WAIT-EVENT-LWLOCK-…
  continue reading
 
In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to build a parquet file archive solution and we discuss the completion of the summer of upgrades. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/epi…
  continue reading
 
What do chess clocks, jazz, and Postgres replication have in common? In Episode 32 of Talking Postgres, solution architect Boriss Mejías shares how the idea of “interconnectedness”—inspired by Douglas Adams—can help you untangle complex Postgres questions. We explore OpenAI’s approach to scaling Postgres, how Postgres active-active mirrors Sparta’s…
  continue reading
 
Discover ACA Dynamic Sessions, a versatile, container-based, low-latency compute platform that allows you to execute LLM-generated code securely and with low cold-start latency. Chapters 00:00 - Introduction 00:44 - Background 02:03 - Introduction to Dynamic Sessions 04:15 - Demo: using LangChain with Dynamic Sessions 07:30 - Demo: using Dynamic Se…
  continue reading
 
In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres restart. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/386-postgres-18-the-deep-cuts/ Want…
  continue reading
 
Nik and Michael discuss user management in Postgres — how roles work, making administration easier, setting passwords, and avoiding them being logged. Here are some links to things they mentioned: Roles https://www.postgresql.org/docs/current/user-manag.html Privileges https://www.postgresql.org/docs/current/ddl-priv.html ALTER DEFAULT PRIVILEGES h…
  continue reading
 
This week on Azure Friday, Scott Hanselman meets with Nick Greenfield to learn about the Azure Functions Durable Task Scheduler. The Durable Task Scheduler is a fully managed backend for orchestrating stateful workflows across Azure compute environments. It powers Durable Functions and Durable Task SDKs with built-in reliability, automatic retries,…
  continue reading
 
In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply, adding not null as not valid and more! To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/385-postgres-18-relea…
  continue reading
 
Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts towards the future. Here are some links to things they mentioned: Postgres 18 announcement https://www.postgresql.org/about/news/postgresql-18-released-3142 Postgres 18 release notes https://www.postgresql.org…
  continue reading
 
We will see how the new popular PostgreSQL extension for VSCode multiplies productivity of PostgreSQL developers with the power of Copilot. In the live demo we will design database schema, visualize it, find a performance issue in the PostgreSQL query and fix it with the help of Copilot. Finally, we'll build an app to compare breweries between Wash…
  continue reading
 
In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/384-preparing-for-postgres-18/ Want to learn more about Postgres performance…
  continue reading
 
Six years, a prototype, and a brief multi-layered descent into “wronger and wronger” design—what does it take to land a major architectural change in Postgres? In Episode 31 of Talking Postgres, Andres Freund—major contributor, Postgres committer, and lead of the Asynchronous I/O project—shares the wins, the missteps, and why he thinks AIO definite…
  continue reading
 
Nik and Michael are joined by Harry Brundage from Gadget to talk about their recent zero-downtime major version upgrade, how they use Postgres more generally, their dream database, and some challenges of providing Postgres as an abstracted service at scale. Here are some links to things they mentioned: Harry Brundage https://postgres.fm/people/harr…
  continue reading
 
In this video Minnie talks about the Metadata Security Protocol security feature on Azure Instance Metadata Service that helps mitigate security risks by only allowing authenticated applications to communicate with the Host endpoints. Chapters 00:00 - Introduction 01:46 - How Metadata Security Protocol works with Azure Instance Metadata 02:49 - Sta…
  continue reading
 
This week on Azure Friday, Scott Hanselman meets with Vamshi Kommineni and Eitan Bremler to explore and demo how Microsoft is helping organizations protect cloud storage data at the core of their applications—by embedding intelligent, built-in posture management, threat protection, and malware scanning directly into Azure Blob Storage through its d…
  continue reading
 
This week on Azure Friday, Scott Hanselman meets with Anusha Subramanian to demo Azure Databox and Azure Storage Mover, learning how to demystify storage migrations. See how these Azure tools can help you move petabytes of data easily and quickly to Azure Storage. Moving large amounts of data can be complex, but with the right tools and AI you can …
  continue reading
 
The video describes the new Logic Apps Hybrid deployment model that allows customers to run their integration workloads in their own Kubernetes environments. This is ideal for customers initiating their journey to the cloud and hosting multiple on-premises workloads, who need to meet industry regulations, who wants to reuse their own Kubernetes inf…
  continue reading
 
In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and methods resolve to slow order by limit queries. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/383-orioledb-more-free/ Want to learn more about P…
  continue reading
 
Nik and Michael are joined by Simon Eskildsen from turbopuffer — among other things, they discuss ANN index types, tradeoffs that can make sense for search workloads, and when it can make sense to move search out of Postgres. Here are some links to things they mentioned: Simon Eskildsen https://postgres.fm/people/simon-eskildsen turbopuffer https:/…
  continue reading
 
This week on Azure Friday, Scott Hanselman meets with Jan Kalis to demo Azure Code Optimizations for .NET. See how Azure’s AI-driven capabilities help you find real-world performance issues in your apps, ground Copilot suggestions with production data, and even help auto-generate PRs with benchmarked code fixes with GitHub Copilot software agent. W…
  continue reading
 
In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sharded databases and a blue/green rollback. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/382-db-llm-agents/ Want to learn more about Po…
  continue reading
 
Nik and Michael discuss when not to use Postgres — specifically use cases where it still makes sense to store data in another system. Here are some links to things they mentioned: Just use Postgres (blog post by Ethan McCue) https://mccue.dev/pages/8-16-24-just-use-postgres Just Use Postgres for Everything (blog post by Stephan Schmidt) https://www…
  continue reading
 
In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/381-documentdb-movement/ Want to learn more about Postgres performance? Join my FRE…
  continue reading
 
Nik and Michael discuss disks in relation to Postgres — why they matter, how saturation can happen, some modern nuances, and how to prepare to avoid issues. Here are some links to things they mentioned: Nik’s tweet demonstrating a NOTIFY hot spot https://x.com/samokhvalov/status/1959468091035009245 Postgres LISTEN/NOTIFY does not scale (blog post b…
  continue reading
 
In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustrations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/380-storage-engine-progress/ Want to learn more about Postgres performance? Join my F…
  continue reading
 
Nik and Michael discuss multi-column indexes in Postgres — what they are, how to think about them, and some guidance around using them effectively. Here are some links to things they mentioned: Multicolumn Indexes (docs) https://www.postgresql.org/docs/current/indexes-multicolumn.html Our episode on Index-only scans https://postgres.fm/episodes/ind…
  continue reading
 
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 recommendations when doing performance optimizations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/379-unconventional-advice/ Want to learn mor…
  continue reading
 
Why do Postgres developers, contributors, and users do what they do? In each episode of Talking Postgres, Claire Giordano talks to people from across the Postgres ecosystem—how they got started, what they’ve learned, and what they’re still figuring out. This 3-minute trailer offers a fast-paced glimpse into the fun, surprising, and deeply human sto…
  continue reading
 
Nikolay and Michael discuss self-driving Postgres — what it could mean, using self-driving cars as a reference, and ideas for things to build and optimize for in this area. Here are some links to things they mentioned: Nikolay’s blog post on Self-driving Postgres https://postgres.ai/blog/20250725-self-driving-postgres SAE J3016 levels of driving au…
  continue reading
 
In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication slot deep dive. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/378-native-column-store/ Want to learn more ab…
  continue reading
 
It’s always a good day if you see a pelican. In Episode 30 of Talking Postgres with Claire Giordano, open source developer Simon Willison—creator of Datasette and co-creator of Django—joins to explore how AI is useful for data engineers today. We move past the hype and boosterism to dig into example after example: structured data extraction, alt te…
  continue reading
 
Nikolay and Michael discuss case-insensitive data — when we want to treat columns as case-insensitive, and the pros and cons of using citext, functions like lower(), or a custom collation. Here are some links to things they mentioned: citext https://www.postgresql.org/docs/current/citext.html Our episode on over-indexing https://postgres.fm/episode…
  continue reading
 
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 and just enough text searching performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/377-sharding-at-network-speeds/ Want to learn more about …
  continue reading
 
NeonDB is a pioneering serverless PostgreSQL database designed for cloud-native environments, fundamentally characterized by its separation of compute and storage layers. Founded in 2021, it has rapidly grown to manage over 700,000 databases within three years, offering features like instant database branching (allowing writable copies in seconds),…
  continue reading
 
In this episode of Scaling Postgres, we discuss a 100K events per second queue built on Postgres, how an MCP can leak your database, MultiXact ID and space overrun and struggles starting Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/376-100k-events-per-second-queue/ Want to …
  continue reading
 
Nikolay talks to Michael about Postgres AI's new monitoring tool — what it is, how its different to other tools, and some of the thinking behind it. Here are some links to things they mentioned: postgres_ai monitoring https://gitlab.com/postgres-ai/postgres_ai DB Lab 4.0 announcement https://github.com/postgres-ai/database-lab-engine/releases/tag/v…
  continue reading
 
In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improvements and a deep dive into Multigres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/375-all-the-benchmarks/ Want to learn more about Postgres pe…
  continue reading
 
Loading …
Copyright 2025 | Privacy Policy | Terms of Service | | Copyright
Listen to this show while you explore
Play