Path To Citus Con, for developers who love Postgres-logo

Path To Citus Con, for developers who love Postgres

Technology Podcasts

Path To Citus Con is for developers who love Postgres. Guests join co-hosts Claire Giordano and Pino de Candia to discuss the human side of open source, databases, PostgreSQL, and the many PG extensions (including Citus.) Produced as a monthly live show on Discord by the Postgres team at Microsoft, subscribe to our calendar to join us live: https://aka.ms/PathToCitusCon-cal.

Location:

United States

Description:

Path To Citus Con is for developers who love Postgres. Guests join co-hosts Claire Giordano and Pino de Candia to discuss the human side of open source, databases, PostgreSQL, and the many PG extensions (including Citus.) Produced as a monthly live show on Discord by the Postgres team at Microsoft, subscribe to our calendar to join us live: https://aka.ms/PathToCitusCon-cal.

Language:

English


Episodes

From developer to PostgreSQL specialist with Derk van Veen

2/9/2024
The best days are when things don’t go as planned. Derk van Veen joined Claire Giordano and Pino de Candia on this podcast for developers who love Postgres—to discuss his journey from Java developer to PostgreSQL specialist and DBA. From his first days with DB2 and Oracle, to his work with Postgres, Derk shared how he learned about databases. And how a very smart colleague would break the database on purpose, to give Derk the tough job of fixing it. Another topic: what to do when you need to jump on a problem but your heart rate doubles? What will it take to get that magical feeling of fixing something in the database? And a segue into sharing your expertise as a speaker at Postgres conferences. Because it’s always about the why. Links mentioned in this episode: https://www.youtube.com/watch?v=SkxwaN46K88https://pathtocituscon.transistor.fm/episodes/why-giving-talks-at-postgres-conferences-mattershttps://www.adyen.com/knowledge-hub/maintenance-under-pressurehttps://stephenking.com/works/nonfiction/on-writing-a-memoir-of-the-craft.htmlhttps://en.wikipedia.org/wiki/PechaKuchahttps://github.com/gciolli/pgChesshttps://www.postgresql.eu/events/fosdem2023/schedule/session/4196-fighting-write-amplification-by-stimulating-hot-updates-through-the-fill-factor/https://www.adyen.com/knowledge-hub/postgresql-hot-updates https://www.postgresql.eu/events/fosdem2024/schedule/session/5164-high-available-configurations-are-very-common-for-postgresql-but-how-do-you-investigate-performance-problems-when-the-standby-cant-keep-up/ https://www.postgresql.eu/events/fosdem2024/sessions/session/5164/slides/460/HA_delay_analysis.pdfhttps://twitter.com/DevrimGunduz/status/1753348159026130959?s=20https://www.chess.com/terms/blitz-chesshttps://aka.ms/posette-cfp-2024

Duration:01:11:16

My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco Slot

1/12/2024
No one likes benchmarking. But it can be one of the highest impact things you do. Jelte Fennema-Nio and Marco Slot joined Claire Giordano and Pino de Candia on this podcast for developers who love Postgres—to discuss their journeys into performance benchmarking. And how it can change the course of your career. Do you need to find bottlenecks in your Postgres? Do you want to build skills with database benchmarks? There are many lovely benchmarking tools in the Postgres world: HammerDB, pgbench, YCSB, BenchBase, perf, & more. And in addition to running benchmarks themselves—asking the right questions, introspection, and profiling matter just as much. Links mentioned in this episode: https://pathtocituscon.transistor.fm/episodes/working-in-public-on-open-sourcehttps://en.wikipedia.org/wiki/Streetlight_effecthttps://db.cs.cmu.edu/projects/benchbase/https://www.hammerdb.com/https://speakerdeck.com/melanieplageman/intro-to-benchmarking-with-pgbenchhttps://locust.io/https://www.citusdata.com/blog/2022/03/12/how-to-benchmark-performance-of-citus-and-postgres-with-hammerdb/https://wiki.postgresql.org/wiki/Profiling_with_perfhttps://www.brendangregg.com/flamegraphs.htmlhttps://www.brendangregg.com/overview.htmlhttps://www.youtube.com/watch?v=HghP4D72Nochttps://www.youtube.com/watch?v=4_smHyqgDTU&t=52shttps://godbolt.org/https://twitter.com/MarkCallaghanDBhttps://2024.pgconf.dev/cfp/https://gigaom.com/report/transaction-processing-price-performance-testing/https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/

Duration:01:13:35

My Journey into Postgres Monitoring with Lukas Fittl & Rob Treat

12/8/2023
Do you monitor your Postgres error logs for gold? Lukas Fittl and Rob Treat join Claire Giordano and Pino de Candia on the Path To Citus Con podcast for developers who love Postgres—to discuss their respective journeys into Postgres monitoring. Have you ever asked yourself: “Why is my query so slow?” Or had to figure out which query is slowing things down? Or why your database server is at 90% CPU? There are so many ways to monitor Postgres: pganalyze, pgMustard, pgBadger, pgDash, your cloud provider’s Query Performance Insights, pg_stat_statements, pg_stat_io, & more. If you’re running Postgres on a managed service, what kinds of things do you need to monitor & optimize for (vs. what will your cloud service provider do)? There’s also a segue on monitoring vs. observability: what’s the difference? Links mentioned in this episode: https://opentelemetry.io/https://pganalyze.com/https://pgdash.io/https://www.pgmustard.com/https://www.postgresql.org/docs/current/pgstatstatements.htmlhttps://github.com/ossc-db/pg_hint_planhttps://github.com/ossc-db/pg_hint_plan/blob/master/docs/hint_list.mdhttps://api.rubyonrails.org/classes/ActiveRecord/QueryMethods.html#method-i-optimizer_hintshttps://www.youtube.com/playlist?list=PLhqxwIAgz78HZhWyu3UyKrCWNk7VWjVpjhttps://wiki.postgresql.org/wiki/Monitoringhttps://github.com/ankane/pgherohttps://techcommunity.microsoft.com/t5/azure-database-for-postgresql/community-insights-on-pgbadger-a-pgsql-phriday-010-recap/ba-p/3880911https://docs.honeycomb.io/getting-data-in/logs/postgresql/https://pganalyze.com/blog/pg-stat-iohttps://andyatkinson.com/blog/2023/11/01/PostgreSQL-IO-Visibility-wehack-pg_stat_iohttps://github.com/iovisor/bpftracehttps://jnidzwetzki.github.io/2023/01/11/trace-postgresql-locks-with-pg-lock-tracer.htmlhttps://github.com/draios/sysdighttps://www.timescale.com/blog/using-bpftrace-to-trace-postgresql-vacuum-operations/https://www.postgresql.org/list/https://www.postgresql.org/docs/current/app-psql.htmlhttps://commitfest.postgresql.org/46/2837/https://github.com/circonus-labs/reconnoiter/tree/master/sqlhttps://twitter.com/as_w/status/1648373353214885892https://www.heavybit.com/library/podcasts/o11ycast/ep-63-observability-in-the-database-with-lukas-fittl-of-pganalyzehttps://oxide-and-friends.transistor.fm/

Duration:01:21:02

Solving every data problem in SQL w/Dimitri Fontaine & Vik Fearing

11/3/2023
Is being lazy a good reason to learn SQL? Dimitri Fontaine and Vik Fearing join Claire Giordano and Pino de Candia on the Path To Citus Con podcast for developers who love Postgres—to discuss whether every data problem can be (or should be) solved in SQL. Have you tried to solve all the Advent of Code puzzles with SQL? Or written a book for application developers about The Art of PostgreSQL? Or tried to solve a murder mystery by running SQL queries? Regardless of whether you pronounce SQL as “sequel” or as “ess-cue-ell”, getting skilled at SQL is like going to the gym for exercise. It’s ideal to do it every day to build up your strength. Also, this episode includes an explanation of what a “declarative” language like SQL is—plus a fun segue into time zones. Links mentioned in this episode, in the order they were covered: https://tapoueh.org/https://adventofcode.com/https://theartofpostgresql.com/https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-newhttps://pgexercises.com/https://mystery.knightlab.com/https://github.com/pgvector/pgvectorhttps://github.com/xocolatl/advent-of-codehttps://github.com/pgtreats/stackoverflow_in_pghttps://www.openstreetmap.org/#map=4/38.01/-95.84https://github.com/fivethirtyeight/uber-tlc-foil-responsehttps://data.world/data-society?entryTypeLabel=dataset&tab=resourceshttps://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_timestamp_.28without_time_zone.29

Duration:01:17:06

How I got started as a developer (& in Postgres) with Andres Freund & Heikki Linnakangas

10/13/2023
Lots of stories of how folks got started as developers! Andres Freund and Heikki Linnakangas join Claire Giordano and Pino de Candia to explore more paths for getting into Postgres on Path To Citus Con, the podcast for developers who love Postgres. How do you do development: with a cup of coffee, with music in the background, maybe at 3am? How do you approach mentoring other developers? Why did you stick with Postgres and make it a career? Lots of lively discussion about building not only code, but relationships in the community, in the open. Also, stories about Heikki’s and Andres’s first Postgres patch submissions, and working via the hackers mailing list. Finally, what advice would you give to your younger self starting in the development world? Links mentioned in this episode, in the order they were covered: https://neon.tech/https://twitter.com/shanselman/status/1610805353255677953https://pathtocituscon.transistor.fm/episodes/how-i-got-started-as-a-developer-in-postgreshttps://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c43feefa806c81d68115ed03a7f723720cefad31https://2023.pgconf.nyc/ https://www.google.com/books/edition/Flow/QVjPsd1UukEChttps://www.postgresql.org/list/pgsql-hackers/https://www.postgresql.org/community/contributors/https://www.postgresql.org/developer/core/https://postgresweekly.com/

Duration:01:13:25

Why people care about PostGIS and Postgres with Paul Ramsey & Regina Obe

9/8/2023
The geospatial world of Postgres is so much more than mapping. Paul Ramsey and Regina Obe join Claire Giordano and Pino de Candia to explore the "where" on Path To Citus Con, the podcast for developers who love Postgres. What are some of the unexpected use cases for PostGIS, one of the most popular extensions to Postgres? How have Large Language Models helped in the geospatial world? Can you really model almost anything with pgRouting? “Where” is the universal foreign key. They talk about communities and governments using geospatial data and how it's very difficult to build a database that does not have some sort of spatial component to it. Why do people care about PostGIS? Find out more about OpenStreetMap and its place in the open source geospatial world. Finally, Paul and Regina share the origin story for the PostGIS extension to Postgres. Links mentioned in this episode, in the order they were covered: https://postgis.net/https://foss4gna.org/https://www.ushahidi.com/https://www.hotosm.org/https://www.openstreetmap.org/https://pgrouting.org/https://locatepress.com/book/pgrhttps://www.manning.com/books/postgis-in-action-third-edition?experiment=Bhttps://github.com/MobilityDB/MobilityDBhttps://techcommunity.microsoft.com/t5/azure-database-for-postgresql/analyzing-gps-trajectories-at-scale-with-postgres-mobilitydb-amp/ba-p/1859278https://www.osgeo.org/https://simonwillison.net/2023/Aug/3/weird-world-of-llms/https://qgis.org/en/site/https://docs.qgis.org/3.28/en/docs/gentle_gis_introduction/https://postgis.net/documentation/training/#workshophttps://locatepress.com/https://www.fedgeo.us/about-2023https://foss4gna.org/schedule.html#schedulehttps://www.osgeo.org/foundation-news/foss4g-2024-has-been-awarded-to-belem-brazil/https://docs.google.com/presentation/d/1xyXA4-0wmNX7WfiLeH9h10bIkZxrej278-mMaClagys/edit?usp=sharing

Duration:01:10:10

You're probably already using Postgres: What you need to know with Chelsea Dole & Floor Drees

8/11/2023
Drop the fear, not the tables. Chelsea Dole and Floor Drees join Claire Giordano and Pino de Candia to explore the app developer perspective on Path To Citus Con, the podcast for developers who love Postgres. If you’re an app developer, you’re probably already using Postgres. Now what? What do you need to know? Are databases your best friend or your worst enemy? They talk about the steps to becoming more Postgres-savvy. Should you go depth-first or breadth-first in order to learn more about the underlying database? What are Postgres extensions and how do you go about adopting them? Find out more about the strength of what Floor calls “boring technology.” Finally, both guests tell stories of their non-traditional entries into Postgres that led to their deep work with databases today. Links mentioned in this episode: https://www.brex.com/https://aiven.io/https://www.youtube.com/watch?v=_NBQ9JmOMkohttps://bigmachine.io/products/the-imposters-handbook/https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/https://devopsdays.org/events/2023-amsterdam/welcome/https://www.lastweekinaws.com/podcast/screaming-in-the-cloud/building-community-in-open-source-with-floor-drees/https://www.postgresql.org/docs/current/pgstatstatements.htmlhttps://postgis.net/https://www.citusdata.com/blog/2020/05/20/postgres-tips-for-django-and-python/https://youtu.be/dyBLGjCQJHshttps://grafana.com/https://pganalyze.com/https://www.postgresql.org/docs/current/auto-explain.htmlhttps://www.postgresql.org/docs/current/sql-explain.htmlhttps://www.postgresguide.com/utilities/psql/https://pathtocituscon.transistor.fm/episodes/my-favorite-ways-to-learn-more-about-postgresql-with-grant-fritchey-and-ryan-boozhttps://coffeemeetsbagel.com/

Duration:01:10:01

My favorite ways to learn more about PostgreSQL with Grant Fritchey & Ryan Booz

7/14/2023
Everyone learns differently. Grant Fritchey and Ryan Booz, database advocates at Redgate focusing on PostgreSQL, talk with co-hosts Claire Giordano and Pino de Candia to explore the learning resources available to developers and users in all the corners of the PostgreSQL world. What drives you to learn: need or curiosity? What can podcasts teach us while we bike to work? Are conference talks good for growing skills, or are they better for networking? What about books? And do older books still have much to offer? It turns out, most people need much more than one approach to build their knowledge. Some of the (many) links shared in the order they were mentioned: Point-in-time query tuning and observability with pg_stat_statementsLearning PostgreSQL with Grantpostgres.fm, a weekly podcast about all things PostgresPath To Citus Con Episode 01: Working in public on open sourcePlanet PostgreSQLCooperpress, including the Postgres Weekly emailScaling PostgreSQL with Creston JamisonPostgreSQL Community User Groupspganalyze "5 minutes of Postgres," by Lukas FittlThe Art of PostgreSQL, by Dimitri FontainePostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta DombrovskayaSQL Performance Explained, by Markus WinandModern SQL, by Markus WinandUse The Index, Luke, by Markus WinandDatabase Administration, by Craig MullinsA Curious Moon, by Rob ConeryThe Little SQL Book, by Rob ConeryPGDay ChicagoRedgate – Simple TalkQuarantine (2020)First Dose (2021)Second Dose (2021)Booster (2022)Crunchy Data’s Postgres PlaygroundCYBERTECCitus Open Source Blog How To Make Your Postgres Blog Posts Reach A Ton More People, by Claire GiordanoPGCon 2023 PGConf.EU, 2022Citus Con: An Event for Postgres 2023PGConf NYC 2023PGSQL Phriday, created by Ryan BoozPostgreSQL Person of the Week, by Andreas Scherbaum Robert Haas' blogselect * from depesz;PostgreSQL 14 internals, by Egor Rogov

Duration:01:18:03

How I got started as a dev and in Postgres with Melanie Plageman & Thomas Munro

7/6/2023
Melanie Plageman, a PostgreSQL hacker working at Microsoft, and Thomas Munro, PostgreSQL developer and committer also as Microsoft talk with co-hosts Claire Giordano and Pino de Candia. They talk through all the different ways they got started as developers. Does making your first patch to Postgres get you hooked for a lifetime? Do you have to be a tinkerer to be a good software engineer? What is the “toothbrush test”—and how do you make your avocation be your vocation? We hear stories about dropping out of school or dropped out of career fields before they found their true passions in development and Postgres. Some of the links mentioned in the order they were said: Parallelism in PostgreSQL 15:Additional IO Observability in Postgres with pg_stat_io:Visualizing PostgreSQL I/O Performance for DevelopmentAdd pg_stat_io view, providing more detailed IO statistics,StarTalkFrom Nand to TetrisSinclair ZX81All Things OpenPostgreSQL BuildFarmQueues in PostgreSQL:

Duration:01:17:26

Why give talks at Postgres conferences with Álvaro Herrera & Boriss Mejías

7/6/2023
Álvaro Herrera, and Boriss Mejías, both longtime members of the Postgres developer community, explore the value of giving conference talks—as well as the work involved, the time it takes, and the many different types of conference talks, including presentations about about failure and things that have gone wrong. Claire and Pino guide the conversation on questions like: Should you add humor to your talks? How does your personality—introvert or extrovert—affect your conference presentations? Is it OK to give the same conference talk at different events? Some of the links mentioned in the order they appeared: Postgres Storytelling: Support in the Darkest HourA Curious MoonTomas Vondra's talks on YouTubepgDay Paris 2022FOSDEM PostgreSQL devroomFOSDEM PGDAY 2023Nordic PGDay 2022PGConf.EU 2022LFMF: How a CREATE INDEX CONCURRENTLY led to a 6 hour downtime

Duration:01:04:46

How to get Postgres ready for the next 100 million users

7/3/2023
Join Claire and Pino as they talk with Citus and Postgres open source team members to explore how to get Postgres ready for the next 100 million users. What will future Postgres users look like? How will the Postgres development process evolve with more users? What are the common challenges faced by Postgres users? Citus open source team members Abdullah Ustuner and Burak Yucesoy are joined by Postgres open source teammates Melanie Plageman and Samay Sharma—and co-hosts Claire Giordano and Pino de Candia—in this episode of Path To Citus Con. Listen to the deep dive on what it means to scale the code and the community far beyond the Postgres world of today. Some links from the show in the order they were mentioned: Additional IO Observability in PostgresOptimizing Postgres for write heavy workloads ft. Checkpoint and WAL configsThe Design of PostgresHyperLogLogPostGIS timescale/pgspot

Duration:01:01:30

Working in public on open source with Simon Willison & Marco Slot

6/29/2023
Simon Willison is the creator of Datasette and co-creator of Django. Marco Slot is the lead architect for the Citus database extension to Postgres. In this episode, Simon and Marco talk about working in public on open source. Simon shares many of his learnings in public—with weeknotes, tweets, blogs, and “today I learned” (TIL) posts. Marco has been developing Citus in public since it was first open sourced in 2016. Hosted by Claire Giordano and Pino de Candia from the Postgres team at Microsoft, listen to find out how working in public can help “future you”—and how there are selfish benefits to be had by working in open source. (Also: how to stay positive in the face of critics?) Some of the topics covered in the order they were mentioned: Simon's weeknotesSimon's TIL postsDatasette pluginsCitus open source GitHub repoFibonacci Spirals and Ways to Contribute to Postgres—Beyond Code Big Opportunities in Small DataThe Distributed PostgreSQL Problem and How Citus Solves It

Duration:01:05:02