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
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
In 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

1
Why Python developers just use Postgres with Dawn Wages
1:00:49
1:00:49
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
1:00:49When I found out that Django developer and Python Software Foundation chair Dawn Wages has a chapter in her upcoming Domain-Driven Django book called “Just Use Postgres”, I knew we had to get her on the show. In this episode of Talking Postgres with Claire Giordano, Dawn breaks down why so many Python and Django developers have such an affinity for…
…
continue reading
Nikolay and Michael discuss GIN indexes in Postgres — what they are, what they're used for, and some limitations to be aware of. Here are some links to things they mentioned: GIN Indexes https://www.postgresql.org/docs/current/gin.html Generalized Search Trees for Database Systems (Hellerstein, Naughton, Pfeffer) https://dsf.berkeley.edu/papers/vld…
…
continue reading

1
Is the Future Immutable? | Scaling Postgres 356
15:21
15:21
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
15:21In this episode of Scaling Postgres, we discuss immutability and Postgres, the upcoming Postgres Conference in Orlando, extended statistics and usage of default partitions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/356-is-the-future-immutable/ Want to learn more about Postgres per…
…
continue reading
Nikolay and Michael use a recent "best practices" article as a prompt — giving a few tips each on the topics mentioned, like schema design, performance, backups, and more. Here are some links to things they mentioned: 7 Crucial PostgreSQL Best Practices (recent blog post) https://speakdatascience.com/postgresql-best-practices “Don't do this” episod…
…
continue reading

1
Top Ten Analytics with pg_mooncake | Scaling Postgres 355
15:59
15:59
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
15:59In this episode of Scaling Postgres, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgres transactions, sharding to scale and connection counts. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/355-top-ten-analytics-with-pg_moonca…
…
continue reading
Nikolay and Michael discuss the CREATE STATISTICS feature in Postgres — what it's for, how often it's used, and how to spot cases where it would help. Here are some links to things they mentioned: CREATE STATISTICS https://www.postgresql.org/docs/current/sql-createstatistics.html citext https://www.postgresql.org/docs/current/citext.html Statistics…
…
continue reading

1
Postgres & The US Treasury Attack | Scaling Postgres 354
15:43
15:43
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
15:43In this episode of Scaling Postgres, we discuss the role of Postgres in the US Treasury online attack, new releases of Postgres, optimizing application of streaming changes and a query that filled a databases disks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/354-postgres-us-treasur…
…
continue reading

1
OLTP To Parquet For Analytics | Scaling Postgres 353
15:59
15:59
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
15:59In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining and partitioning advice. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/353-oltp-to-parquet-for-analytics/ Want to learn more about Postgres …
…
continue reading
Nikolay and Michael are joined by Franck Pachot to discuss SQL vs NoSQL — did Franck change teams by joining MongoDB, normalisation vs denormalisation, developer experience, NULLs, and more! Here are some links to things they mentioned: Franck Pachot https://postgres.fm/people/franck-pachot Franck's workshop at PGConf India https://pgconf.in/confer…
…
continue reading

1
You Can Always Optimize More | Scaling Postgres 352
14:32
14:32
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
14:32In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best practices. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/352-you-can-always-optimize-more/ Want to learn more about Postgres performance? Join …
…
continue reading

1
Why mentor Postgres developers with Robert Haas
1:26:23
1:26:23
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
1:26:23Nobody works on an open-source project forever—eventually, people move on. So of course today's Postgres contributors want to see more developers join the project, pick up the torch, and continue to make Postgres amazing. Hence the importance of mentorship. In this episode of Talking Postgres with Claire Giordano, PostgreSQL major contributor and c…
…
continue reading
Nikolay and Michael return to the topic of BUFFERS for the third (and final?) time! They discuss the news that it'll be on by default with EXPLAIN ANALYZE in Postgres 18, and what effect that might have. Here are some links to things they mentioned: Our first BUFFERS episode https://postgres.fm/episodes/buffers-by-default Our second BUFFERS episode…
…
continue reading

1
Features To Avoid? | Scaling Postgres 351
16:55
16:55
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
16:55In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a way to detect a table rewrite and a zero downtime upgrade. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/351-features-to-avoid/ Want to lear…
…
continue reading

1
Seven Years of Scaling Postgres | Scaling Postgres 350
19:09
19:09
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
19:09In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by statistics. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/350-seven-years-of-scaling-postgres/ Want to learn more a…
…
continue reading
Nikolay and Michael discuss a couple of surprising ways read queries (selects) can cause writes (shared buffers dirtied) in Postgres. Here are some links to things they mentioned: Reads causing writes in Postgres (post by Alex Jesipow) https://jesipow.com/blog/postgres-reads-cause-writes/ Exploring how SELECT queries can produce disk writes (post b…
…
continue reading

1
The Dangers of Temporary Tables | Scaling Postgres 349
15:24
15:24
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
15:24In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and table level lock considerations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/349-the-dangers-of-temporary-tables/ Want to learn more abo…
…
continue reading

1
How I got started as a developer & in Postgres with Daniel Gustafsson
1:22:31
1:22:31
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
1:22:31March 5th 2005 at 3 PM in Copenhagen. That’s the exact time and place Daniel Gustafsson’s career took an unexpected turn, pivoting from operating systems to databases. At LinuxForum that day, Daniel had planned to meet up with the FreeBSD community, but a chance session about Postgres by Bruce Momjian completely blew his mind. By the time Daniel wa…
…
continue reading
Nikolay and Michael discuss adding constraints in an online fashion, using NOT VALID and then VALIDATE CONSTRAINT. Here are some links to things they mentioned: ADD table_constraint NOT VALID https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-DESC-ADD-TABLE-CONSTRAINT Our episode on zero-downtime migrations https://postgres.…
…
continue reading

1
The Future Is Containers? | Scaling Postgres 348
12:28
12:28
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
12:28In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/348-the-future-is-containers/ Want to learn more about Postgres performance? Join my FREE training cal…
…
continue reading
Michael and Nikolay are joined by Antonín Houska to discuss pg_squeeze — what it is, how it started, some of its features, and hopes of getting the functionality into core. Here are some links to things they mentioned: Antonín Houska https://postgres.fm/people/antonin-houska pg_squeeze https://github.com/cybertec-postgresql/pg_squeeze Cybertec http…
…
continue reading
Michael and Nikolay are joined by Joe Sciarrino and Jelte Fennema-Nio to discuss pg_duckdb — what it is, how it started, what early users are using it for, and what they're working on next. Here are some links to things they mentioned: Joe Sciarrino https://postgres.fm/people/joe-sciarrino Jelte Fennema-Nio https://postgres.fm/people/jelte-fennema-…
…
continue reading

1
Easy Incremental Data Processing? | Scaling Postgres 347
14:47
14:47
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
14:47In this episode of Scaling Postgres, we discuss the new pg_incremental extension for processing data pipelines, a set of Postgres monitoring queries, handling alter table retries and large object dump performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/347-easy-incremental-data…
…
continue reading
Nikolay and Michael discuss Row Level Security in Postgres, focussing on the performance side effects and some tips to avoid (or minimize) them. Here are some links to things they mentioned: Row Security Policies (docs) https://www.postgresql.org/docs/current/ddl-rowsecurity.html 7+ million Postgres tables (recent talk by Kailash Nadh) https://www.…
…
continue reading

1
Things I Don't Do In Postgres | Scaling Postgres 346
15:47
15:47
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
15:47In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special data types or create 7+ millions tables in a database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/346-things-i-do-not-do-in-postgres/ Want to lea…
…
continue reading
Michael and Nikolay are joined by Lukas Eder, the creator of jOOQ, to discuss what it is, some nice developer experience features it has, and some fun things he's come across from a Postgres perspective. Here are some links to things they mentioned: Lukas Eder https://postgres.fm/people/lukas-eder jOOQ https://www.jooq.org/ DSL https://en.wikipedia…
…
continue reading

1
Over 5X Faster Postgres? | Scaling Postgres 345
17:02
17:02
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
17:02In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whether you should us track_planning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/345-over-5x-faster-postgres/ Want to learn more about P…
…
continue reading

1
Leading engineering for Postgres on Azure with Affan Dar
1:05:52
1:05:52
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
1:05:52What’s it like to lead Postgres engineering at a cloud giant like Microsoft Azure? In this episode of Talking Postgres, host Claire Giordano chats with Affan Dar, VP of Engineering for Postgres at Microsoft. Affan’s team is behind the Azure Database for PostgreSQL managed service and also contributes extensively to the upstream Postgres open-source…
…
continue reading
Nikolay and Michael discuss "Column Tetris" — what it is, why it matters, how to order columns for new tables, and how to re-organise existing ones. Here are some links to things they mentioned: “Column Tetris” by Erwin Brandstetter on Stack Overflow https://stackoverflow.com/questions/2966524/calculating-and-saving-space-in-postgresql/7431468#7431…
…
continue reading

1
Performance & Hard Things | Scaling Postgres 344
17:38
17:38
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
17:38In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/344-performance-hard-things/ Want to learn more about Postgres performance? Join my FREE trai…
…
continue reading

1
pg_stat_statements track_planning
37:55
37:55
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
37:55Nikolay and Michael discuss the track_planning parameter of pg_stat_statements — what it is, how it affects performance, and when or whether you should switch it on. Here are some links to things they mentioned: pg_stat_statements.track_planning https://www.postgresql.org/docs/current/pgstatstatements.html#id-1.11.7.40.9.2.4.1.3 Our episode about p…
…
continue reading

1
Postgres Release Warning! | Scaling Postgres 343
18:50
18:50
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
18:50In this episode of Scaling Postgres, we discuss new Postgres releases and an out-of-band release to address issues, increasing insert performance by 2X, pg_search benchmarks and fast OpenStreetMap loading. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/343-postgres-release-warning/ Wan…
…
continue reading
Michael and Nikolay are joined by Gülçin Yıldırım Jelínek and Robert Haas to discuss both the technical question of whether or not pg_dump is a backup tool, as well as the tone and intent behind the statement "pg_dump is not a backup tool". Here are some links to things they mentioned: Gülçin Yıldırım Jelínek https://postgres.fm/people/gulcin-yildi…
…
continue reading

1
Faster Writes With ZFS? | Scaling Postgres 342
13:19
13:19
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
13:19In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, denormalization and a new pgvector release. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/342-faster-writes-with-zfs/ Want to learn more ab…
…
continue reading

1
Helping Rails developers learn Postgres with Andrew Atkinson
1:34:26
1:34:26
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
1:34:26Have you ever achieved something remarkable because someone planted an idea in your mind? In this episode of Talking Postgres, host Claire Giordano talks with Andrew Atkinson—a Rails developer and Postgres user whose journey to becoming a published author began with a simple seed of inspiration. Andrew’s story started with an internal presentation …
…
continue reading
Nikolay and Michael discuss append-only tables in Postgres — what they are, some unique challenges they bring, and some options for compressing / removing / offloading the data eventually. Here are some links to things they mentioned: Append-only https://en.wikipedia.org/wiki/Append-only Our episode on BRIN indexes https://postgres.fm/episodes/brin…
…
continue reading

1
S3E2: Heikki Linnakangas, Cofounder Neon
27:00
27:00
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
27:00Today we take a deep dive into the world of PostgreSQL extensions, featuring our conversation with Heikki Linnakangas, co-founder of Neon, an expert Postgres hacker, and contributor to pgvector. Heikki shares the fascinating story of how Neon was born in 2021, driven by the vision of creating an open-source platform akin to Aurora Serverless. He de…
…
continue reading

1
The Future of Postgres Upgrades | Scaling Postgres 341
14:15
14:15
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
14:15In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and limitless Aurora. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/341-the-future-of-postgres-upgrades/ Want to learn more about Postgres per…
…
continue reading
Nikolay and Michael discuss denormalization in Postgres — when and why to denormalize things, and a couple of specific cases Nikolay came across recently. Here are some links to things they mentioned: Denormalization https://en.wikipedia.org/wiki/Denormalization Our episode on materialized views https://postgres.fm/episodes/materialized-views Our e…
…
continue reading

1
Do You Need A Vectorizer? | Scaling Postgres 340
16:39
16:39
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
16:39In this episode of Scaling Postgres, we discuss whether you need a vectorizer, different ways to bin or bucket timestamps, addressing a bad plan and advanced psql. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/340-do-you-need-a-vectorizer/ Want to learn more about Postgres performance…
…
continue reading

1
Postgres online communities
38:09
38:09
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
38:09Nikolay and Michael discuss online Postgres communities — the ones they prefer, the types of conversations in each, and some other places to ask questions or follow news. Here are some links to things they mentioned: https://www.postgresql.org/community Mailing lists https://www.postgresql.org/list IRC https://www.postgresql.org/community/irc Slack…
…
continue reading

1
Postgres Goes Parquet | Scaling Postgres 339
11:32
11:32
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
11:32In this episode of Scaling Postgres, we discuss pg_parquet allowing Postgres to read and write parquet files, other useful extensions, open source bounties, and Postgres gotchas. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/339-postgres-goes-parquet/ Want to learn more about Postgres…
…
continue reading
Nikolay and Michael discuss some cool things you can do with psql, the official CLI that ships with Postgres. Here are some links to things they mentioned: psql docs https://www.postgresql.org/docs/current/app-psql.html Our episode on psql vs GUIs https://postgres.fm/episodes/psql-vs-guis postgres_dba https://github.com/NikolayS/postgres_dba Our ep…
…
continue reading

1
S3E1: Francesco Tisiot, Field CTO Aiven
31:46
31:46
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
31:46Joining Aiven in 2021, Francesco Tisiot works as a Field CTO and AI Lead. He serves as a technical advisor to clients and prospects, helping to meet their needs without the focus on sales, acting as a 'rented' CTO to provide expert guidance. Join us as we dive into Francesco's insightful perspectives on the Postgres community, where he challenges t…
…
continue reading

1
JSON Goodies In Postgres 17 | Scaling Postgres 338
17:03
17:03
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
17:03In this episode of Scaling Postgres, we discuss the JSON goodies in Postgres 17, trigger recursion, pg_dump as backup and pg_timeseries columnar performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/338-json-goodies-in-postgres-17/ Want to learn more about Postgres performance? J…
…
continue reading
Nikolay and Michael discuss some Postgres Gotchas, things you might expect to work one way in fact working another way. Here are some links to things they mentioned: Our episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown Postgres Gotchas (list by Ian Barwick) https://sql-info.de/postgresql/postgres-gotchas…
…
continue reading

1
77 Times Faster In Postgres 17 | Scaling Postgres 337
14:19
14:19
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
14:19In this episode of Scaling Postgres, we discuss how one query runs 77 times faster in Postgres 17, a detailed Postgres 17 performance webinar, using logical replication fail over slots and a discussion on Patroni. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/337-77-times-faster-in-po…
…
continue reading

1
How I got started as a developer (& in Postgres) with Tom Lane
1:39:18
1:39:18
Lire Plus Tard
Lire Plus Tard
Des listes
J'aime
Aimé
1:39:18It was not Tom Lane’s plan to become a computer person. Tom’s plan was to be a pinball machine designer. And yet for the last 26 years Tom has been one of the most prolific engineering contributors to Postgres. In this episode of Talking Postgres with Claire Giordano, PostgreSQL luminary Tom Lane walks us through how he got his start as a developer…
…
continue reading
Nikolay and Michael discuss some more advanced topics around EXPLAIN, including some tips for complex query plans, some recent improvements, and an idea or two that might make it even better. Here are some links to things they mentioned: Michael’s solo episode on EXPLAIN basics https://postgres.fm/episodes/explain Our episode on auto_explain https:…
…
continue reading