A weekly podcast about all things 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
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
All about extensions, extension creators, and people doing cool things with Postgres. New episodes every week.
…
continue reading

1
DocumentDB Movement | Scaling Postgres 381
9:44
9:44
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
9:44In 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

1
Talking Postgres with Claire Giordano – Trailer
2:53
2:53
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
2:53Why 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

1
Storage Engine Progress? | Scaling Postgres 380
14:53
14:53
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
14:53In 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

1
Unconventional Advice? | Scaling Postgres 379
19:03
19:03
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
19:03In 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
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

1
Native Column Store? | Scaling Postgres 378
19:29
19:29
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
19:29In 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

1
AI for data engineers with Simon Willison
1:15:58
1:15:58
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
1:15:58It’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

1
Sharding At Network Speeds | Scaling Postgres 377
15:14
15:14
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
15:14In 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

1
100K Events Per Second Queue | Scaling Postgres 376
19:45
19:45
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
19:45In 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

1
All The Benchmarks | Scaling Postgres 375
16:19
16:19
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
16:19In 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

1
MultiXact member space exhaustion
55:43
55:43
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
55:43Nikolay and Michael are joined by Andrew Johnson and Nate Brennand from Metronome to discuss MultiXact member space exhaustion — what it is, how they managed to hit it, and some tips to prevent running into it at scale. Here are some links to things they mentioned: Nate Brennand https://postgres.fm/people/nate-brennand Andrew Johnson https://postgr…
…
continue reading

1
Migrating Millions Of Databases | Scaling Postgres 374
18:34
18:34
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
18:34In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and mastering replication slots. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/374-migrating-millions-of-databases/ Want to learn more abo…
…
continue reading

1
How I got started leading database teams with Shireesh Thota
57:21
57:21
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
57:21From dreaming of driving a bus to leading database engineering at Microsoft. In Episode 29 of Talking Postgres with Claire Giordano, Shireesh Thota traces his path to becoming CVP of Azure databases—rooted in a love of math, early BASIC programming, and a certainty that he’d become an engineer. We dig into the shift from engineer to manager (if onl…
…
continue reading
Nikolay and Michael are joined by Sugu Sougoumarane to discuss Multigres — a project he's joined Supabase to lead, building an adaptation of Vitess for Postgres! Here are some links to things they mentioned: Sugu Sougoumarane https://postgres.fm/people/sugu-sougoumarane Supabase https://supabase.com Announcing Multigres https://supabase.com/blog/mu…
…
continue reading

1
Planetscale Postgres! | Scaling Postgres 373
14:22
14:22
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
14:22In this episode of Scaling Postgres, we discuss the release of Planetscale Postgres and the advantages for bare metal, how often queries are optimal, avoiding UUIDv4 and the summer of upgrade report. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/373-planetscale-postgres/ Want to learn…
…
continue reading

1
The Future of Postgres Architecture | Scaling Postgres 372
19:26
19:26
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
19:26In this episode of Scaling Postgres, we discuss some possible futures for Postgres architectures, choosing a multi-tenancy model, vectors in the new SQL standard and one way to perform a blue-green deployment rollback in AWS RDS. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/372-the-f…
…
continue reading

1
Are You Hurting Your Performance? | Scaling Postgres 371
21:08
21:08
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
21:08In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some downsides of different upgrade methods. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/371-are-you-hurting-your-performance/ Want to lear…
…
continue reading

1
12 years of Postgres Weekly with Peter Cooper
1:16:54
1:16:54
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
1:16:54What drives someone to publish 600+ issues of a Postgres newsletter for over a decade? In Episode 28 of Talking Postgres with Claire Giordano, Peter Cooper—creator of Postgres Weekly—shares how his days of rustic programming and QBASIC fanzines on Usenet led to a newsletter empire that now reaches nearly half a million developers each week. We dig …
…
continue reading
Nikolay and Michael are joined by Gwen Shapira to discuss multi-tenant architectures — the high level options, the pros and cons of each, and how they're trying to help with Nile. Here are some links to things they mentioned: Gwen Shapira https://postgres.fm/people/gwen-shapira Nile https://www.thenile.dev SaaS Tenant Isolation Strategies (AWS whit…
…
continue reading

1
New Scale Out Options | Scaling Postgres 370
14:51
14:51
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
14:51In this episode of Scaling Postgres, we discuss the start of Multigres which is a Vitess for Postgres, pgactive going open source, getting started with logical replication and a summer of upgrades. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/370-new-scale-out-options/ Want to learn …
…
continue reading
Nikolay and Michael discuss looking at queries by mean time — when it makes sense, why ordering by a percentile (like p99) might be better, and the merits of approximating percentiles in pg_stat_statements using the standard deviation column. Here are some links to things they mentioned: Approximate the p99 of a query with pg_stat_statements (blog …
…
continue reading

1
Move Off Of RDS? | Scaling Postgres 369
18:01
18:01
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
18:01In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries and a novel way to migrate to partition tables. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/369-move-off-of-rds/ Want to learn more a…
…
continue reading
Nikolay and Michael discuss logging in Postgres — mostly what to log, and why changing quite a few settings can pay off big time in the long term. Here are some links to things they mentioned: What to log https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT Our episode about Auditing https://postgres.fm/ep…
…
continue reading

1
4 Times Faster UUID Primary Keys | Scaling Postgres 368
19:10
19:10
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
19:10In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to migrate to partition tables with low downtime. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/368-4-times-faster-u…
…
continue reading
Nikolay and Michael discuss moving off managed services — when and why you might want to, and some tips on how for very large databases. Here are some links to things they mentioned: Patroni https://github.com/patroni/patroni pgBackRest https://github.com/pgbackrest/pgbackrest WAL-G https://github.com/wal-g/wal-g Hetzner Cloud https://www.hetzner.c…
…
continue reading

1
How Often Does That Query Run? | Scaling Postgres 367
13:10
13:10
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
13:10In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/367-how-often-does-that-query-run/ Want to learn more about Pos…
…
continue reading
Nikolay and Michael discuss heavyweight locks in Postgres — how to think about them, why you can't avoid them, and some tips for minimising issues. Here are some links to things they mentioned: Locking (docs) https://www.postgresql.org/docs/current/explicit-locking.html Postgres rocks, except when it blocks (blog post by Marco Slot) https://www.cit…
…
continue reading

1
20,000 Times Faster Order By Limit | Scaling Postgres 366
14:46
14:46
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
14:46In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit issue. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/366-20k-faster-…
…
continue reading

1
Here Comes Async I/O! | Scaling Postgres 365
20:01
20:01
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
20:01In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/365-here-comes-async-io/ Want to learn more about Postgres performance?…
…
continue reading

1
How I got started with FerretDB (& why we chose Postgres) with Peter Farkas
1:29:53
1:29:53
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
1:29:53How does a trek to K2 base camp in the Himalayas spark the idea for a database company? In Episode 27 of Talking Postgres with Claire Giordano, guest Peter Farkas—CEO and co-founder of FerretDB—shares the origin story of this open source MongoDB alternative. (Spoiler: “Ferret” wasn’t the original name). We dig into why Postgres was the obvious choi…
…
continue reading
Nikolay and Michael discuss ten dangerous Postgres related issues — ones that might be painful enough to get onto the CTO and even CEOs desk, and then what you can do proactively. The ten issues discussed are: Heavy lock contention Bloat control and index maintenance Lightweight lock contention Transaction ID wraparound 4-byte integer PKs hitting t…
…
continue reading

1
Scaling For High Volume | Scaling Postgres 364
20:39
20:39
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
20:39In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/364-scaling-for-high-volume/ Want to learn more about Postgres performance…
…
continue reading
Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each. Here are some links to things they mentioned: synchronous_commit https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT synchronous_commit …
…
continue reading

1
Top Ten Postgres Dos & Don'ts | Scaling Postgres 363
13:32
13:32
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
13:32In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how to handle disaster recovery. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/363-top-ten-postgres-dos-and-do…
…
continue reading
Nikolay and Michael discuss managed service support — some tips on how to handle cases that aren't going well, tips for requesting features, whether to factor in support when choosing service provider, and whether to use one at all. Here are some links to things they mentioned: YugabyteDB’s new upgrade framework https://www.yugabyte.com/blog/postgr…
…
continue reading

1
Optimizing For Time-Series Data | Scaling Postgres 362
12:22
12:22
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
12:22In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/362-optimizing-for-time-series-data/ Want to learn more abo…
…
continue reading

1
A Roadmap To Scaling Postgres | Scaling Postgres 361
17:28
17:28
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
17:28In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and efficient use of foreign keys. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/361-roadmap-to-scaling-postgres/ Wa…
…
continue reading
Nikolay and Michael discuss time-series considerations for Postgres — including when it matters, some tips for avoiding issues, performance considerations, and more. Here are some links to things they mentioned: Time series data https://en.wikipedia.org/wiki/Time_series TimescaleDB https://github.com/timescale/timescaledb 13 Tips to Improve Postgre…
…
continue reading

1
Handle One Million Connections? | Scaling Postgres 360
16:17
16:17
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
16:17In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port 5432 and Postgres on Kubernetes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/360-ha…
…
continue reading

1
Open Source Leadership with Bruce Momjian
1:48:21
1:48:21
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
1:48:21What does it take to lead a global open source project like Postgres? In Episode 26 of Talking Postgres with Claire Giordano, we sit down with Bruce Momjian—co-founder and core team member of the PostgreSQL Global Development Group—to explore the art of leadership in a volunteer-run open source community. Bruce shares what “servant leadership” real…
…
continue reading
Nikolay and Michael are joined by Tomas Vondra to discuss single query performance cliffs — what they are, why they happen, some things we can do to make them less likely or less severe, and some potential improvements to Postgres that could help. Here are some links to things they mentioned: Tomas Vondra https://postgres.fm/people/tomas-vondra Whe…
…
continue reading

1
Trillions of Rows & Metrics | Scaling Postgres 359
18:27
18:27
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
18:27In this episode of Scaling Postgres, we talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for deletion use cases. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/359-trillions-of-row…
…
continue reading
Nikolay and Michael are joined by Lev Kokotov to discuss PgDog — including whether or when sharding is needed, the origin story (via PgCat), what's already supported, and what's coming next. Here are some links to things they mentioned: Lev Kokotov https://postgres.fm/people/lev-kokotov PgDog https://github.com/pgdogdev/pgdog PgCat https://github.c…
…
continue reading

1
Postgres Conference 2025 | Scaling Postgres 358
23:37
23:37
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
23:37In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. Interestingly, at least from my perspective, the most well attended talks seemed to cover pg_vector, analytics involving duckdb and partitioning. To get the show notes as well as get notified of new epi…
…
continue reading
Nikolay talks Michael through using cloud snapshots — how they can be used to reduce RTO for huge Postgres setups, also to improve provisioning time, and some major catches to be aware of. Here are some links to things they mentioned: Snapshots on RDS https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html pgBackRest https:/…
…
continue reading

1
Postgres Best Practices? | Scaling Postgres 357
9:58
9:58
נגן מאוחר יותר
נגן מאוחר יותר
רשימות
לייק
אהבתי
9:58In this episode of Scaling Postgres, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the importance of monitoring wait events. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/357-postgres-best-practices/ Want to learn more about Po…
…
continue reading