Τα καλύτερα Postgres podcast (2024)

1
Postgres 17 42:03

1d ago42:03

42:03

Nikolay and Michael discuss the fresh new Postgres 17 release! They cover several performance improvements, favourite new features, and some considerations for upgrading. Here are some links to things they mentioned: Postgres 17 release notes https://www.postgresql.org/docs/17/release-17.html transaction_timeout episode https://postgres.fm/episodes…

1
Optimizing For Analytics | Scaling Postgres 334 21:55

6d ago21:55

21:55

In this episode of Scaling Postgres, we discuss how to optimize your database for analytics, how to speed up counts, improvements to TimescaleDB and why you should stop using serial. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/334-optimizing-for-analytics/ Want to learn more about P…

1
Becoming a Postgres committer with Melanie Plageman 1:22:38

9d ago1:22:38

1:22:38

If you could work on anything, would you quit your job to pursue it? Postgres committer and major contributor Melanie Plageman joined Claire Giordano on this episode of the Talking Postgres podcast (formerly Path To Citus Con) to share her story about becoming a Postgres committer. Melanie pivoted from IT consulting to open-source development, driv…

1
Planning time 42:17

9d ago42:17

42:17

Nikolay and Michael discuss planning time in Postgres — what it is, how to spot issues, its relationship to things like partitioning, and some tips for avoiding issues. Here are some links to things they mentioned: Query Planning (docs) https://www.postgresql.org/docs/current/runtime-config-query.html Are there limits to partition counts? (Blog pos…

1
When Select Writes! | Scaling Postgres 333 13:38

13d ago13:38

13:38

In this episode of Scaling Postgres, we discuss when select can write, Postgres RC1 is released, Tetris in SQL and copy, swap, drop. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/333-when-select-writes/ Want to learn more about Postgres performance? Join my FREE training called Postgr…

1
Slow count 43:25

16d ago43:25

43:25

Nikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale. Here are some links to things they mentioned: Aggregate functions (docs) https://www.postgresql.org/docs/current/functions-aggregate.html PostgREST https://github.com/PostgREST/postgrest Get rid of count by default in Pos…

1
Sometimes It Is Slow? | Scaling Postgres 332 15:10

20d ago15:10

15:10

In this episode of Scaling Postgres, we discuss what can happen when queries get slow, backup best practices, Postgres emergencies and the state of Postgres survey. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/332-sometimes-it-is-slow/ Want to learn more about Postgres performance? J…

1
Skip scan 57:49

23d ago57:49

57:49

Michael and Nikolay are joined by Peter Geoghegan, major contributor and committer to Postgres, to discuss adding skip scan support to PostgreSQL over versions 17 and 18. Here are some links to things they mentioned: Peter Geoghegan https://postgres.fm/people/peter-geoghegan Peter’s previous (excellent) interview on Postgres TV https://www.youtube.…

1
Is pg_dump A Backup Tool? | Scaling Postgres 331 17:31

27d ago17:31

17:31

In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for the merge command. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/331-is-pg_dump-a-backup-tool/ Want to learn more about Postgres perfor…

1
Postgres Emergency Room 45:27

30d ago45:27

45:27

Nikolay and Michael discuss PostgreSQL emergencies — both the psychological side of incident management, and some technical aspects too. Here are some links to things they mentioned: Site Reliability Engineering resources from Google https://sre.google GitLab Handbook SRE https://handbook.gitlab.com/job-families/engineering/infrastructure/site-reli…

1
Splicing Elephant & Duck DNA | Scaling Postgres 330 14:58

1M ago14:58

14:58

In this episode of Scaling Postgres, we discuss the merging of Postgres and DuckDB via the pg_duckdb extension, how this can help the analytics story for Postgres, some ways to improve PG analytics and building a search engine. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/330-splicin…

1
Get or Create 50:19

1M ago50:19

50:19

Michael and Nikolay are joined by Haki Benita, a technical lead and database enthusiast who writes an excellent blog and gives popular talks and training sessions too, to discuss the surprisingly complex topic of trying to implement “get or create” in PostgreSQL — handling issues around idempotency, concurrency, and bloat. Here are some links to th…

1
PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329 19:01

1M ago19:01

19:01

In this episode of Scaling Postgres, we discuss PGlite, an embeddable Postgres, postgres.new which adds AI features, new Postgres releases and the performance of synchronous replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/329-pglite-embeddable-postgres/ Want to learn more a…

1
Getting started with benchmarking 56:32

1M ago56:32

56:32

Michael and Nikolay are joined by Melanie Plageman, database internals engineer at Microsoft and major contributor and committer to PostgreSQL, to discuss getting started with benchmarking — how it differs for users and developers of Postgres, how and when it comes up during development, some tools and lessons, as well as what she's working on at t…

1
Implement Get Or Create | Scaling Postgres 328 16:10

2M ago16:10

16:10

In this episode of Scaling Postgres, we discuss different get or create implementations, a new pgBouncer version, alter default privileges, and six degrees of separation with Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/328-implement-get-or-create/ Want to learn more about …

1
How I got started as a developer (& in Postgres) with David Rowley 1:29:08

2M ago1:29:08

1:29:08

Ever wonder how driving a forklift at a cheese factory could lead to a career in databases? Postgres committer David Rowley joined Claire Giordano on this episode of the Talking Postgres podcast (formerly Path To Citus Con) to share his story about how he got started as a developer and in Postgres. Could an unexpected job lead to your dream career?…

1
Index-Only Scans 39:15

2M ago39:15

39:15

Nikolay and Michael discuss Index-Only Scans in Postgres — what they are, how they help, some things to look out for, and some advice. Here are some links to things they mentioned: Index-Only Scans and Covering Indexes (docs) https://www.postgresql.org/docs/current/indexes-index-only-scans.html Discussion on Twitter about JIT and Parallel Query def…

1
Postgres Graph Queries | Scaling Postgres 327 16:30

2M ago16:30

16:30

In this episode of Scaling Postgres, we discuss using Postgres for graph queries, the fastest way to copy data from one table to another, dealing with linux memory overcommit and compression. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/327-postgres-graph-queries/ Want to learn more …

1
Why Postgres? 41:00

2M ago41:00

41:00

Nikolay and Michael discuss why they chose Postgres — as users, for their businesses, for their careers, as well as some doubts. Here are some links to things they mentioned: Our episode on why Postgres become popular https://postgres.fm/episodes/why-is-postgres-popular Database Systems: The Complete Book (by Hector Garcia-Molina, Jeff Ullman, and …

1
Faster Index Creation | Scaling Postgres 326 20:28

2M ago20:28

20:28

In this episode of Scaling Postgres, we talk about speeding up index creation, extensions to track wait events, a row pattern recognition feature and savepoints. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/326-faster-index-creation/ Want to learn more about Postgres performance? Joi…

1
Compression 45:16

2M ago45:16

45:16

Nikolay and Michael discuss compression in Postgres — what's available natively, newer algorithms in recent versions, and several extensions with compression features. Here are some links to things they mentioned: wal_compression https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-WAL-COMPRESSION Our episode on WAL and checkpoint tu…

1
Faster Paging? | Scaling Postgres 325 20:07

2M ago20:07

20:07

In this episode of Scaling Postgres, we discuss more ways to keep the superior performance of keyset pagination, how to implement UUIDv7 in SQL functions, how expensive extended statistics are and the benefits of range columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/325-faster-…

1
Out of disk 43:26

2M ago43:26

43:26

Nikolay and Michael discuss Postgres running out of disk space — including what happens, what can cause it, how to recover, and most importantly, how to prevent it from happening in the first place. Here are some links to things they mentioned: Disk Full (docs) https://www.postgresql.org/docs/current/disk-full.html pgcompacttable https://github.com…

1
Four Million TPS | Scaling Postgres 324 16:29

3M ago16:29

16:29

In this episode of Scaling Postgres, we discuss experiments to achieve four million transaction per second, the importance of extended statistics, parallelism in Postgres and an introduction to window functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/324-four-million-tps/ Want …

1
Podcasting about Postgres with Pino de Candia 1:24:09

3M ago1:24:09

1:24:09

Have you ever eavesdropped on other people’s conversations? Former co-host Pino de Candia joins Claire Giordano on this episode of Talking Postgres (formerly Path To Citus Con) to share their experience on podcasting about Postgres. Is listening to a podcast the next best thing to being in the hallway track at a conference? Does it bring the commun…

1
Postgres startup ecosystem 35:42

3M ago35:42

35:42

Nikolay and Michael discuss the Postgres startup ecosystem — some recent closures, some recent fundraising announcements, and their thoughts on where things are going and what they'd like to see. Here are some links to things they mentioned: Prediction from Dax Raad https://x.com/thdxr/status/1808972166752580039 OtterTune shut down https://x.com/an…

1
PgBouncer Breaking Change | Scaling Postgres 323 23:47

3M ago23:47

23:47

In this episode of Scaling Postgres, we discuss a breaking change in the new version of PgBouncer, PostgreSQL 17 Beta 2 is released, examination of the new built-in collation provider in PG 17 and Notion's data lake. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/323-pgbouncer-breaking…

1
Four million TPS 45:50

3M ago45:50

45:50

Nikolay talks Michael through a recent experiment to find the current maximum transactions per second single-node Postgres can achieve — why he was looking into it, what bottlenecks occurred along the way, and ideas for follow up experiments. Here are some links to things they mentioned: How many TPS can we get from a single Postgres node? (Article…

1
S2E10: DJ Patil and Ray Lane, GreatPoint Ventures 44:18

3M ago44:18

44:18

Today we’re joined by Ray Lane and DJ Patil from GreatPoint Ventures. Ray, known for his pivotal role at Oracle during its turnaround, shares his journey from the US Army to top tech positions and eventually co-founding GreatPoint Ventures, where he supports entrepreneurs. DJ Patil – investor, entrepreneur, and former U.S. Chief Data Scientist – jo…

1
Postgres Sort Instability? | Scaling Postgres 322 19:48

3M ago19:48

19:48

In this episode of Scaling Postgres, we discuss an incremental sort instability issue with the Postgres planner, whether we should use foreign keys, how the visibility map works and how to vacuum the template0 database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/322-postgres-sort-i…

1
Soft delete 37:40

3M ago37:40

37:40

Nikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementations suit which use cases. Here are some links to things they mentioned: Soft deletion probably isn't worth it (blog post by Brandur) https://brandur.org/soft-deletion Easy alternative soft deletion (blog post …

1
Ottertune Is Dead! | Scaling Postgres 321 11:02

3M ago11:02

11:02

In this episode of Scaling Postgres, we discuss the shutdown of Ottertune, how schema changes cause locks and how to avoid them, the benefits of on conflic do nothing, and pgvectorscale. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/321-ottertune-is-dead/ Want to learn more about Post…

1
The Making of POSETTE: An Event for Postgres with Teresa Giacomini & Aaron Wislang 1:35:04

3M ago1:35:04

1:35:04

It’s not a conference unless you can confer, right? POSETTE organizers Teresa Giacomini and Aaron Wislang join Claire Giordano on the Path To Citus Con* podcast to share backstage perspectives on the making of POSETTE: An Event for Postgres. How do you feel about captions: love or hate? Should livestream talks be pre-recorded or presented live? Why…

1
Should we use foreign keys? 51:21

3M ago51:21

51:21

Nikolay and Michael discuss foreign keys in Postgres — what they are, their benefits, their overhead, some edge cases to be aware of, some improvements coming, and whether or not they generally recommend using them. Here are some links to things they mentioned: Foreign keys (docs) https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CON…

1
100 TB and Beyond! | Scaling Postgres 320 17:32

3M ago17:32

17:32

In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory and new AI extensions To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/320-100tb-and-beyond/ Want to learn more about Postgres performance…

1
pgvectorscale 55:27

4M ago55:27

55:27

Nikolay is joined by Mat Arye and John Pruitt, from Timescale, to discuss their new extension pgvectorscale and high-performance vector search in Postgres more generally. Main links: https://github.com/timescale/pgvectorscale https://www.timescale.com/blog/pgvector-vs-pinecone https://postgres.fm/people/matvey-arye https://postgres.fm/people/john-p…

1
When Postgres Development Stopped! | Scaling Postgres 319 12:05

4M ago12:05

12:05

In this episode of Scaling Postgres, we discuss a time when Postgres development stopped, two new extensions pg_lakehouse & pg_compare and the upcoming event Posette. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/319-when-postgres-development-stoppped/…

1
To 100TB, and beyond! 47:42

4M ago47:42

47:42

Michael and Nikolay are joined by three special guests for episode 100 who have all scaled Postgres to significant scale — Arka Ganguli from Notion, Sammy Steele from Figma, and Derk van Veen from Adyen. They cover how their setup has evolved, what their plans are for the future, and get into the weeds of some fun and interesting challenges along t…

1
Postgres 17 Beta 1 Released | Scaling Postgres 318 17:54

4M ago17:54

17:54

In this episode of Scaling Postgres, we discuss all the new features in Postgres 17 Beta 1, some features that did not make it, database collations & sorting and causes of slow commits. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/318-postgres-17-beta-1-released/…

1
Sponsoring the community 32:17

4M ago32:17

32:17

Michael is joined by Claire Giordano, Head of Postgres Open Source Community Initiatives at Microsoft, to discuss several ways to contribute to the Postgres community — from core contributions, to extensions, to events, and (of course) podcasts. Here are some links to things they mentioned: What’s new with Postgres at Microsoft (blog post by Claire…

1
S2E9: Sai Srirampur, PeerDB 41:37

4M ago41:37

41:37

Sai Srirampur is the co-founder of PeerDB and a veteran Postgres Solutions Engineer with experience at Citus Data and Microsoft. He has been at the forefront of optimizing and scaling Postgres for large data workloads and is now spearheading innovation in data movement and replication with PeerDB. In this episode, we'll discuss the challenges of tu…

1
Time-Series Open Source Extension | Scaling Postgres 317 14:56

4M ago14:56

14:56

In this episode of Scaling Postgres, we discuss a new time-series open source extension called pg_timeseries, Postgres ignoring indexes, JSONB selectivity issues, and geographically distributed multi-tenant applications. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/317-time-series-op…

1
Full text search 50:20

4M ago50:20

50:20

Nikolay and Michael discuss full text search in Postgres — some of the history, some of the features, and whether it now makes sense to try to replace or combine it with semantic search. Here are some links to things they mentioned: Full Text Search https://www.postgresql.org/docs/current/textsearch.html tsearch2 https://www.postgresql.org/docs/9.6…

1
S2E8: Melanie Plageman, Microsoft 36:55

4M ago36:55

36:55

In this episode, we talk Postgres committer Melanie Plagemean about her involvement with @PGConfdev, improvements to vacuum scheduling and auto vacuum configuration, the logical replication of DDL, and platforms such as CNCF and Kubernetes integrating with Postgres. Links mentioned: PGConf.dev YouTube – CMU Database Group Path To Citus Con Podcast …

1
New Releases & 1,000 Times Faster Query | Scaling Postgres 316 14:34

4M ago14:34

14:34

In this episode of Scaling Postgres, we discuss new Postgres releases, optimizing a query to be 1,000 times faster, custom vs. generic plans and the pgtt extension. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/316-new-releases-1000-times-faster-query/…

1
Minor releases 39:46

4M ago39:46

39:46

Nikolay and Michael discuss Postgres minor releases — how the schedule works, options for upgrading to them, and the importance of reading the release notes. Here are some links to things they mentioned: PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 released (announcement) https://www.postgresql.org/about/news/postgresql-163-157-1412-1315-and-1219…

1
S2E7: Bharath Rupireddy, AWS 30:08

5M ago30:08

30:08

Bharath Rupireddy has carved a niche for himself in the Postgres community since he began using the database system back in 2020. From his start at EnterpriseDB to making strides at Microsoft, and now contributing to the AWS open-source project, Bharath is entrenched in the inner workings of Postgres development. He has worked in many areas of Post…

1
Hacking On Postgres is Hard! | Scaling Postgres 315 19:31

5M ago19:31

19:31

In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metrics and saturated arithmetic. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/315-hacking-on-postgres-is-hard/…

1
Custom vs generic plan 29:00

5M ago29:00

29:00

Nikolay and Michael discuss custom and generic planning in prepared statements — how it works, how issues can present themselves, some ways to view the generic plan, and some benefits of avoiding planning (not just time). Here are some links to things they mentioned: PREPARE https://www.postgresql.org/docs/current/sql-prepare.html track_activity_qu…

1
S2E6: Gülçin Yıldırım Jelínek, EDB 37:09

5M ago37:09

37:09

As the podcast host of The Builders, member of Postgres Women, and Staff Engineer at EDB, Gülçin Yıldırım Jelínek is passionate to see where this space will take us. We kick off Season 2 with Gülçin as she shares her journey in the tech industry, CloudNativePG, the impact of AI on Postgres, and the representation of women in the Postgres community.…

Podcasts που αξίζει να ακούσετε

Postgres Podcasts

Podcasts που αξίζει να ακούσετε

Οδηγός γρήγορης αναφοράς