POPULARITY
What 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” really means; how saying I'm sorry can help make problems go away; and how letting go of who-gets-the-credit can fuel collaboration. We also dive into Bruce's origin story, from shaping Postgres's early days to mastering the art of public speaking. Pro tip: if you see a man in a bow tie at a Postgres conference, be sure to say hello—it's probably Bruce Momjian!Links mentioned in this episode:Open source project website: postgresql.orgWebsite: Bruce MomjianVideo of talk: Building Open Source Teams at FOSDEM 2023Slides: FOSDEM talk on Building Open Source TeamsWikipedia: John C. MaxwellHarry Truman quote: It is amazing what you can accomplish if you do not care who gets the creditThe New Stack: How to Generate AI From a DatabaseEDB Blog: Bruce Momjian's Insights from PGConf India 2025Conference schedule: PGConf India 2025Book: Why We Sleep by Matthew WalkerVideo of talk: Why Database Teams Need Crew Resource Management by Chris TraversWikipedia: Anna Karenina principleTalking Postgres podcast: Why mentor Postgres developers with Robert HaasDiscord invite: PostgreSQL Hacking serverMailing lists: PostgreSQL mailing listsConference: PostgreSQL Conference Nepal 2025 happening May 5-6Conference: PostgreSQL Conference Germany 2025 on May 8-9Conference: POSETTE: An Event for Postgres 2025 on Jun 10-12Upcoming POSETTE 2025 keynote: Databases in the AI Trenches by Bruce Momjian Conference: SouthEast | LinuxFest on Jun 13-15 in Charlotte NC Conference: Swiss PGDay 2025 happening Jun 26-27 Conference: PGDay Austria 2025 happening in Vienna on Sep 4Conference: PGDay UK 2025 happening in London on Sep 9Conference: PGDay Lowlands 2025 happening in Rotterdam on Sep 12Video from PGConf.dev 2024: Making PostgreSQL Hacking More InclusiveTalking Postgres podcast: How I got started as a developer (& in Postgres) with David RowleyWikipedia: O'Reilly Open Source Convention (OSCON)Calendar invite: LIVE recording of Ep27 of Talking Postgres to happen on Wed May 07 with guest Peter Farkas. The topic: “How I got started with FerretDB (& why we chose Postgres)”
An airhacks.fm conversation with Alvaro Hernandez (@ahachete) about: discussion about stackgres as a complete database cloud solution for PostgreSQL, kubernetes as an abstraction layer over infrastructure providing a programmable API, Stackgres offering high availability with primary and replica nodes using patroni, integrated connection pooling with PgBouncer, kubernetes operators and Custom Resource Definitions (CRDs) as a powerful way to extend Kubernetes, day two operations automated through CRDs including benchmarks and version upgrades, Stackgres supporting sharding with Citus for horizontal scaling similar to DynamoDB, Change Data Capture capabilities using embedded debezium, failover mechanisms taking typically 30 seconds with DNS updates, synchronous vs asynchronous replication options affecting data loss during failover, Stackgres being implemented in Java using quarkus, ContainerD as a programmable container runtime that can be used without Kubernetes, Stackgres offering multiple interfaces including CRDs, REST API, and a web console, considerations for running databases on Kubernetes vs cloud-managed services, the advantages of containerization for infrastructure, the challenges of multi-leader setups in PostgreSQL requiring conflict resolution, the value of Kubernetes for on-premises deployments vs cloud environments Alvaro Hernandez on twitter: @ahachete
When 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 Postgres. And we dive into the Djangonaut Space mentoring program (where contributors launch), learn why “free as in puppies” beats “free as in cake” for open source vibes, and dig into why Python is the second-best language for everything.Links mentioned in this episode:Project page: psycopgDocumentation: Psycopg 3 – PostgreSQL database adapter for PythonProject page: PostgreSQL open source projectGit repo: code for PostgreSQL.org websiteConference: PyCon US 2025, happening May 14-22 in PittsburghConference: PGConf.dev 2025 Schedule, happening May 13-16 in Montreal CanadaConference: Prague PostgreSQL Developer Day 2025 (P2D2) Schedule, which took place Jan 28-29Wikipedia page: Model-view-controller software design patternBook: Professional ASP.NET MVC 1.0, affectionately called “the four heads book”Podcast episode: Working in Public with Simon Willison & Marco SlotBlog: Simon Willison's TILs, aka Things I've learnedSimon Willison's Weblog: Here's how I use LLMs to help me write codeSimon Willison's Weblog: How I make annotated presentationsSurvey: Python Developers Survey 2023 ResultsPython Docs: What's new in Python 3.14Mentorship program: Djangonaut SpaceMentorship program: Media & Talks about Djangonaut SpacePodcast episode: Why mentor Postgres developers with Robert HaasSlides: PGConf EU 2024 talk by Claire Giordano about Contributions to Postgres, including maps showing how global the Postgres project isVideo of POSETTE 2024 talk by Paolo Melchiorre: Semantic search with Django, PostgreSQL, & pgvectorVideo of Citus Con 2023 talk: Maps with Django (and PostGIS), by Paolo MelchiorreVideo of Citus Con 2022 talk: Django with PostgreSQL superpowers, by Paolo MelchiorreConference: DjangoCon Africa 2025, happening August 11-15 in Tanzania Calendar invite: LIVE recording of Ep26 of Talking Postgres to happen on Wed Apr 02, 2025 with guest Bruce Momjian, to talk about Open Source Leadership
Nobody 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 committer Robert Haas shares how he learned the ropes in Postgres by channeling “what would Tom Lane do” during patch reviews; why he launched the new PostgreSQL Hackers Mentoring program; and the intellectually stimulating care and feeding it takes to make Postgres thrive.Links mentioned in this episode:Podcast episode: Becoming a Postgres committer with Melanie Plageman Slide: PGConf EU 2024 talk by Claire Giordano about Contributions to Postgres, including new mentoring programBlog post: New Mentoring Program for Code Contributors in Postgres, by Robert HaasBlog post: Postgres Mentoring Program Updates, by Robert Haas Discord invite for PostgreSQL Hacker Mentoring server: https://discord.gg/bx2G9KWyrYBio: Margo Seltzer, the PGConf.dev 2024 keynote speakerVideo: PGConf.dev 2024 panel discussion about Making PostgreSQL Hacking More Inclusive with Amit Langote, Masahiko Sawada, Melanie Plageman, & Robert HaasMailing list: PostgreSQL HackersUpcoming Conference: PGConf.dev 2025, the annual PostgreSQL Development Conference happening in Montreal Canada on May 13-16, 2025Blog: Postgres committer Tomas Vondra's Blog - Look for [PATCH IDEA] Video of Talk: CMUDB Database talk about PostgreSQL Optimizer Methodology, by Robert HaasPodcast episode: How I got started as a developer & in Postgres with David RowleyCalendar invite: LIVE recording of Ep25 of Talking Postgres podcast to happen on Wed Mar 12, 2025 with guest Dawn Wages of the Python developer community
March 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 was on the train back to Malmö, he was already compiling Postgres. In this episode of Talking Postgres with Claire Giordano, Postgres major contributor and committer Daniel Gustafsson of Microsoft walks us through how he got his start as a developer and in Postgres—starting with his earliest computing memories of a hulking steel box in his family's living room in Sweden. Also part of Daniel's story: guitar tuning software. And curl!Links mentioned in this episode:Wikipedia: ABC 80Wikipedia: mSQLWikipedia: PCBoard BBS (bulletin board system) applicationConference back in 2010: CHAR(10) – Clustering, HA and Replication ConferenceWikipedia: IRIX operating systemInternet Archive Wayback Machine link: LinuxForum Conference Agenda from March 5, 2005 with Bruce Momjian's 3:00pm talk about Postgres Podcast: Solving every data problem in SQL with Dimitri Fontaine & Vik FearingConference: Nordic PGDay 2025 to happen Mar 18th in CopenhagenConference: All Things Open 2025 to happen Oct 12-14 in Raleigh NCConference: PGConf.dev 2025 to happen May 13-16 in Montreal, CanadaCFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 9 2025 (it's a virtual event)Slides from PGConfEU 2024 Talk: What's in a Postgres major release? An analysis of contributions in v17 timeframeVideo of PGConf EU 2024 Talk: Analysis of contributions in the v17 timeframe, by Claire GiordanoBook recommendation: The Dragon Book, a.k.a. Compilers: Principles, Techniques, and ToolsBook recommendation: The Purple Book (or, Wizard Book), a.k.a. Structure and Interpretation of Computer Programs (SICP)Book recommendation: The Practice of Programming by Kernighan & PikeCalendar invite: LIVE recording of Ep24 of Talking Postgres podcast to happen on Wed Feb 05, 2025 with guest Robert Haas
What'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 project. Affan walks us through his career journey—from his first job as an embedded systems engineer, to navigating the shift between engineering and management, to leading one of the largest Postgres engineering teams in the world. He shares the strategy behind Microsoft's investments into Postgres, explores how massive cloud fleets are influencing the future of Postgres, and shares what keeps him up at night.Links mentioned in this episode:Docs: Azure Database for PostgreSQL – Flexible ServerGitHub repo for Durable Task Framework, the first open source project Affan worked onGitHub repo for pgvector open source extension to PostgresDocs: Elastic cluster feature in Azure Database for PostgreSQL – Flexible Server, based on CitusGitHub repo for Citus open sourceBlog post: Postgres horizontal scaling with elastic clusters on Azure Database for PostgreSQL, by Adam WølkGitHub repo for DiskANN open sourceDocs: How to enable and use the DiskANN index for Azure Database for PostgreSQL – Flexible ServerBlog post: Think of language models like ChatGPT as a “calculator for words” by Simon WillisonBlog post: What's new with Postgres at Microsoft (updated 2x/year typically)Video of Talk at Microsoft Ignite: Improving accuracy of GenAI apps with Azure Database for PostgreSQL by Maxim Lukiyanov (Microsoft), Jay Yang (UBS), & Orhun Oezbek (UBS)CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 9 2025Calendar invite: LIVE recording of Ep23 of Talking Postgres podcast to happen on Wed Jan 15, 2025 with guest Daniel Gustafsson
Increase scalability, optimize performance, and integrate advanced AI features with Azure Database for PostgreSQL Flexible Server. Scale up with SSD v2 for up to 4x more transactions per second and significantly lower latency. Scale out effortlessly with elastic clusters using Citus, distributing workloads across multiple servers at no extra cost. Optimize performance with Automatic Index Tuning, reducing server utilization and enhancing efficiency. Leverage advanced AI features like DiskANN, semantic reranking, and Graph RAG to build better AI apps. Charles Feddersen, Partner Director of Program Management for Postgres at Microsoft, joins Jeremy Chapman to show you how to build scalable, high-performance AI apps on Azure PostgreSQL Flexible Server today. ► QUICK LINKS: 00:00 - Azure Database for Postgres Flexible Server 00:39 - Updates to PostGreSQL 01:50 - Faster storage with SSD v2 03:06 - Scale out workloads using elastic cluster 03:59 - Provision an elastic cluster 05:34 - Scale "in-place" 07:12 - Eliminate redundant indexes 07:44 - Optimize server parameters 09:52 - Improve AI apps with Postgres Flexible Server 11:40 - Code behind queries using PG Admin 12:31 - Scale workloads 13:36 - Wrap up ► Link References Get started at https://aka.ms/azurepostgresblog Access code at https://aka.ms/AzurePostgresAI ► Unfamiliar with Microsoft Mechanics? As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. • Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter: https://twitter.com/MSFTMechanics • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/ • Enjoy us on Instagram: https://www.instagram.com/msftmechanics/
Have 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 on how to tackle tricky scalability challenges in Rails, grew into a Postgres conference talk at PGConf NYC—and ultimately evolved into his book, High Performance PostgreSQL for Rails. Also in this episode: what does cheese have to do with Postgres? Is writing a good way to think? What's the connection between Postgres and swimming to Antarctica? And which chapter of his book does Andrew love the most?Links mentioned in this episode:Book: High Performance PostgreSQL for Rails by Andrew Atkinson E-book Discount: Use discount code TalkingPostgres to get 35% off discount of Andrew's bookBlog post: Readers get their copies of High Performance PostgreSQL for Rails by Andrew AtkinsonBook: Swimming to Antarctica: Tales of a Long Distance Swimmer by Lynne CoxTalk Abstract: PGConf NYC 2021 talk by Andrew Atkinson Slides: PGConf NYC 2021 talk on How We Made PG Fitter, Happier, More Productive by Andrew AtkinsonVideo: POSETTE 2024 talk about SaaS on Rails on PostgreSQL by Andrew Atkinson Ruby User Groups: List of upcoming Ruby user groupsBlog post: Writing is Thinking, an annotated twitter thread by Steve Sinofsky Talking Postgres podcast Ep19: Becoming a Postgres committer with Melanie Plageman Talking Postgres podcast Ep20: How I got started as a developer (& in Postgres) with David RowleyCFP: Prague PostgreSQL Developer Day 2025 (P2D2) CFP open until Nov 23, 2024CFP: FOSDEM PGDay 2025 CFP open until Nov 29, 2024CFP: Nordic PGDay 2025 CFP open until Dec 31, 2024CFP: pgDay Paris 2025 CFP open until Dec 31, 2024 CFP: PGConf.dev 2025 CFP open until Jan 01, 2025CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 09, 2025Calendar invite: LIVE recording of Ep22 of Talking Postgres podcast
Spaudos apžvalga.Šiauliuose prasidėjo kasmetis tarptautinis šiuolaikinio meno ir mados festivalis „VIRUS“. 29-tą kartą rengiamas festivalis stebins parodomis, performansais, šokiais, madų šou. Šiųmetis festivalis prasidėjo Kazimiero Brazdžiūno ir Tomo Daukšos paroda „Pokštas“.Klaidingų įsitikinimų vedami žmonės anksčiau vadovavosi eugenikos idėja, kuria buvo skatinama atrinkti neva geresnius individus reprodukcijai. Dėl šios teorijos kai kurios šalys sukūrė netgi įstatymus, pagal kuriuos vykdytos sveikatos patikros. Po jų dažnai nukentėdavo visiškai nekalti asmenys. Kaip atsirado eugenikos idėja ir kokie jos svarbiausi principai? Pasakoja Vesta Vitkutė.Vilniaus universiteto matematikos fakulteto dėstytojas Vytenis Šumskas pripažintas Metų jaunimo influenceriu ir Metų jaunimo darbuotoju.2022 m. parengus ir pernai patvirtinus Veiksmų planą, numatantį Lietuvos piliakalnių apsaugos stiprinimą, jį vykdant atrinkti 138 reikšmingiausi piliakalniai, kuriems bus suformuoti ir įregistruoti žemės sklypai. Teigiama, kad tokiu būdu netrukus bus išspręsta ilgus metus užsitęsusi problema – bešeimininkių ir ne visuomet atidžiai prižiūrimų piliakalnių statusas.Pokalbis su Lietuvos Respublikos Vyriausybės kanceliarijos Viešojo valdymo grupės patarėja Diana Varnaite.Užsienio spaudos apžvalga.Druskininkuose, ilgus metus vaiduokliu buvęs sanatorijos "Nemunas" pastatas atgimė naujam gyvenimui ir įgavo išskirtinę išvaizdą - pastato fasadus papuošė didžiausios pasaulyje Čiurlionio paveikslų reprodukcijos.Apie verslo ir kultūros simbiozę ir didžiausias Čiurlionio reprodukcijas ant „Nemuno by CITUS“ pasatato fasado pokalbis su projektą sumaniusios ir įgyvendinusios įmonės „Citus“ įkūrėju Mindaugu Vanagu.Klaipėdos parodų salėse atidarytos abstrakčiosios tapybos pradininkės Kazės Zimblytės ir Izraelyje kuriančio menininko Leo Rėjaus parodos. Taip pat atidaroma dešimtoji Lietuvos dailininkų sąjungos Klaipėdos skyriaus menininkų paroda „Vakarų vėjai '24“.Ved. Donatas Šukelis
Want to learn more Postgres? Get on the waiting list for the full course: https://masteringpostgres.com. In this interview, I talk with Jesse Hanley, founder of Bento, about running a lean email service from Japan. We chat about the challenges of scaling infrastructure, managing databases, and maintaining a calm business while serving a global customer base. Links Mentioned: Bento: https://bentonow.com Database school on YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15 Database school audio only: https://databaseschool.transistor.fm Follow Jesse: Twitter: https://twitter.com/jessethanley Bento on Twitter: https://twitter.com/Bento Follow Aaron: Twitter: https://twitter.com/aarondfrancis LinkedIn: https://www.linkedin.com/in/aarondfrancis Website: https://aaronfrancis.com - find articles, podcasts, courses, and more. Chapters: 00:00 - Introduction to Jesse Hanley 01:02 - Running Bento from Japan 01:48 - The Lean Team Structure at Bento 03:00 - Managing Support via Discord 05:01 - Benefits of Using Discord for Customer Support 06:45 - The Role of Community in Customer Feedback 09:01 - How Bento Gained Traction 13:00 - Bootstrapping Bento and Profitable Growth 16:00 - Running Your Own Mail Servers 19:03 - The Economics and Redundancy of Email Delivery 21:00 - Bento's Heroku Setup and Scaling Challenges 26:00 - Handling and Querying Massive Data in Bento 29:52 - Leveraging Elasticsearch for Data Queries 35:40 - Moving Toward Multi-Database Solutions 37:45 - Exploring Crunchy Data and Citus for Database Scaling 42:00 - Optimizing Bento for Performance and Scalability 54:02 - Jesse's Advice on Building a Calm and Profitable Business 57:00 - How Bento Uses WebSockets and Background Jobs 1:00:00 - Optimizing Bento with Action Cable 1:02:25 - Avoiding N+1 Queries with WebSockets 1:04:50 - Scaling Redis and Postgres at Bento 1:09:00 - Jesse's Approach to Managing Growth and Multiple Services 1:11:00 - Final Thoughts on Scaling and Optimizing Databases 1:13:10 - Advice for Aspiring Builders: Stay Patient and True to Your Vision 1:16:00 - Bento's Unique Approach to Email Marketing and Transactional Emails 1:19:50 - Closing Thoughts and Where to Find Jesse Hanley Online
It 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 and in Postgres—including his time working on desktop calculators at HP. And how he has code running on Mars (and most of us don't.) During Tom's PhD studies at Carnegie Mellon, nobody told him databases were so interesting! It wasn't until Tom needed a database to store stock trading information that he first got to work with Postgres. And that's when Tom's 26-year-long (and counting) Postgres story began.Links mentioned in this episode:Wikipedia: Tom Lane (computer scientist)Wikipedia: HP 9800 seriesCMU CS Department Coke Machine historyWikipedia: Honeywell 316Wikipedia: Teletype Model 33Wikipedia: Hydra (operating system)Wikipedia: William WulfWikipedia: Jon Bentley (computer scientist)Wikipedia: Mary Shaw (computer scientist)Wikipedia: UsenetGitHub: postgres commit by tglsfdcArticle: The Mars 2020 Engineering Cameras and Microphone on the Perseverance Rover: A Next-Generation Imaging System for Mars Exploration by J.N. Maki et al.Blog: Open Source on Mars: Community powers NASA's Ingenuity Helicopter by Klint FinleyPostgreSQL Mailing List message: pg_upgrade --check fails to warn about abstimePostgreSQL: Core Teampostgresql.git: commitdiffBlog: Proton to Fastmail by Tristan PartinTalking Postgres Ep18: How I got started as a dev (& in Postgres) with David RowleyPGConf EU 2024: Conference SchedulePGConf NYC 2024: Conference ScheduleTalking Postgres Ep19: Becoming a Postgres committer with Melanie PlagemanPostgreSQL: CommitfestsWikipedia: Cutting room floorPostgreSQL Mailing List message: Straight-from-the-horses-mouth deptPostgreSQL Mailing List message: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges
Want to learn more Postgres? Get on the waiting list for the full course: https://masteringpostgres.com. In this interview, I dive deep with Craig Kerstiens from Crunchy Data into the world of Postgres, covering its rise to prominence, scaling at Heroku, and the power of Postgres extensions. Craig also shares insights on database sharding, the future of Postgres, and why developers love working with it. Follow Craig: Twitter: https://twitter.com/craigkerstiens Crunchy Data Blog: https://www.crunchydata.com/blog Follow Aaron: Twitter: https://twitter.com/aarondfrancis LinkedIn: https://www.linkedin.com/in/aarondfrancis Website: https://aaronfrancis.com - find articles, podcasts, courses, and more. Chapters: 00:00 - Introduction: Welcome to Database School 00:20 - Guest Introduction: Craig Kerstiens and Crunchy Data 01:40 - Craig's Journey from Heroku to Crunchy Data 02:55 - Scaling Postgres at Heroku 04:50 - Mastering Postgres Course Announcement 05:30 - The Importance of Postgres at Heroku 07:50 - The Value of Live SQL with Data Clips 09:25 - Data Clips for Business Intelligence and Real-Time Analytics 11:05 - Heroku's Unique Company Culture and How Data Clips Came to Be 12:30 - Postgres Extensions and Marketplace 14:00 - Citus: Scaling Postgres for Multi-Tenant Applications 15:40 - The Challenges of Sharding in Databases 18:00 - Managing Large Databases and Sharding Keys with Citus 24:00 - The Evolution of Postgres and Its Growing Popularity 31:00 - Postgres for Developers and the Importance of Extensions 35:00 - Extensions as Proving Grounds for Core Postgres Features 37:50 - Building an Extension Marketplace for Postgres 41:00 - Postgres as a Data Platform and Developer Flexibility 46:00 - Why Developers Love Postgres: Stability, Extensions, and Ownership 51:00 - DuckDB: A Fascinating New Database Approach 53:30 - Crunchy Data: What They Offer and Why It Matters 58:30 - Expanding Postgres with DuckDB for Data Warehousing 01:00:00 - Wrapping Up: Where to Find Craig and Crunchy Data
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, driven by her fascination with systems engineering and Postgres open source. What's the secret to getting your patch committed? Feedback is a gift, but how willing are you to embrace it? How important is mentorship—and how important is it to ask for help? Even though crafting clear, concise emails to a technical community might not be easy, Melanie shows how empathy for other Postgres developers can help your work to stand out.Links discussed in this episodePgsql-hackers mailing list: Announcement about new Postgres committersConference: PGConf.dev 2025Blog: Talk, then code by Dave ChenyBlog posts about mentoring by Robert HaasBlog: Mentoring Program Updates by Robert HaasX: Brendan Burn's tweet about the Kubernetes Chop Wood and Carry Water awardAward: Chop Wood Carry WaterBlog: Who Contributed to PostgreSQL Development in 2023? by Robert HaasAbstract: What's in a Postgres major release? An analysis of contributions in the v17 timeframe for PGConfEU 2024 by Claire GiordanoTalking Postgres Ep18: How I got started as a developer (& in Postgres) with David RowleyWikipedia: PostgreSQL Contributor GiftsCal invite for next Ep 20 of Talking Postgres with Tom Lane to be recorded LIVE on Wed Oct 9, 2024Podcasts & conference videos that Melanie listens to when running that she recommends to Postgres developers:Podcast: Oxide and FriendsPodcast: postgres.fmPodcast: Software Engineering RadioPodcast: Talking Postgres with Claire GiordanoPodcast: Two's ComplementSE Radio: Ep 432: Brian D Foy on Perl 7Video: Memory & Caches by Matt GodboltVideos: POSETTE 2024 playlistVideo: RailsConf 2014 - All the Little Things by Sandi MetzYouTube: Brandon FoltzYouTube: CMU Database GroupYouTube: Kernel RecipesYouTube: Linux Plumbers ConferenceYouTube: Matt GodboltYouTube: Onur Mutlu LecturesYouTube: pganalyzeYouTube: PostgreSQL Development ConferenceYouTube: SNIAVideoYouTube: Strange Loop ConferenceYouTube: The Linux Foundation
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.htmlPostgREST https://github.com/PostgREST/postgrest Get rid of count by default in PostgREST https://github.com/PostgREST/postgrest/issues/273 Faster PostgreSQL Counting (by Joe Nelson on the Citus blog) https://www.citusdata.com/blog/2016/10/12/count-performance Our episode on Index-Only Scans https://postgres.fm/episodes/index-only-scansPostgres HyperLogLog https://github.com/citusdata/postgresql-hllOur episode on Row estimates https://postgres.fm/episodes/row-estimates Our episode about dangers of NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown Aggregate expressions, including FILTER https://www.postgresql.org/docs/current/sql-expressions.html#SYNTAX-AGGREGATESSpread writes for counter cache (tip from Tobias Petry) https://x.com/tobias_petry/status/1475870220422107137pg_ivm extension (Incremental View Maintenance) https://github.com/sraoss/pg_ivm pg_duckdb announcement https://motherduck.com/blog/pg_duckdb-postgresql-extension-for-duckdb-motherduckOur episode on Queues in Postgres https://postgres.fm/episodes/queues-in-postgresOur episode on Real-time analytics https://postgres.fm/episodes/real-time-analyticsClickHouse acquired PeerDB https://clickhouse.com/blog/clickhouse-acquires-peerdb-to-boost-real-time-analytics-with-postgres-cdc-integrationTimescale Continuous Aggregates https://www.timescale.com/blog/materialized-views-the-timescale-wayTimescale editions https://docs.timescale.com/about/latest/timescaledb-editionsLoose indexscan https://wiki.postgresql.org/wiki/Loose_indexscan~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Kas yra teistumas, kiek jis trunka ir kada išnyksta? Kokią įtaką tolimesniam gyvenimui gali turėti teistumas? Pokalbis su Baudžiamųjų bylų advokatu , Mykolo Romerio universiteto vyr.lektoriumi dr. Laurynu Pakštaičiu.Pirkdami būstą su paskola ar kreditu, dažniausiai turime sudaryti ir hipotekos sutartį. Kas yra hipoteka, kodėj ji reikalinga ir kokių su hipoteka susijusių įsipareigojimų tikrai nevertėtų pažeisti? Komentuoja kūrybiškų NT projektų ir vietokūros kompanijos „Citus“ teisininkė Ieva Pukelienė.„Koks Jūsų dabartinis atlyginimas?“ – tai vienas iš klausimų, kurio darbdaviai po poros metų klausti nebegalėsi, bet užtat bus galima sužinoti kokia kolegų alga. Apie nuo 2026ųjų birželio įsigaliojančią Europos Sąjungos direktyvą dėl užmokesčio skaidrumo kalbame su advokatų kontoros „Glimstedt” darbo teisės ekspertė Brigida Baciene.Ved. Artūras Matusas
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? Does speeding things up give you a buzz? How could an idea from a hike become a Postgres patch? And what is the importance of doing the research before you submit a proposal to the Postgres mailing list? Also discussed: resources available to start your Postgres journey such as books, blogs, videos, and the pgsql-hackers mailing list.Links mentioned in this episode:Wikipedia: Acorn ComputersPostgreSQL Mailing List Archives: David's first email: Possible problem with EXTRACT(EPOCH FROM TIMESTAMP)Google Usenet: Larry Page's Java question from Jan 7, 1996Blog: Speeding up sort performance in Postgres 15 by David RowleyBlog: What's new in the Postgres 16 query planner / optimizer by David RowleyBook: The Art of PostgreSQL by Dimitri FontaineBook: The Art of SQL by Stéphane Faroult, Peter RobsonBook: The Art of Writing Efficient Programs: An advanced programmer's guide to efficient hardware utilization and compiler optimizations using C++ examples by Fedor G. PikusX: Simon Willison's tweetBlog by Tony FinchBook: Daily Rituals: How Artists Work by Mason CurreyGitHub Issue: Coughing in my microphone causes segfaultPostgreSQL Mailing Lists: OverviewPostgreSQL Mailing Lists: pgsql-generalPostgreSQL Mailing Lists: pgsql-hackersVideo: Making your patch more committable by Melanie Plageman at PGConf.EU 2023Cheese company: Seriously StrongTalking Postgres Ep04: How I got started as a dev and in Postgres with Melanie Plageman & Thomas MunroTalking Postgres Ep08: How I got started as a developer (& in Postgres) with Andres Freund & Heikki LinnakangasCal invite for next Ep19 of Talking Postgres with Melanie PlagemanCal invite for next Ep 20 of Talking Postgres with Tom Lane
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/1808972166752580039OtterTune shut down https://x.com/andy_pavlo/status/1801687420330770841Snaplet shutting down https://www.snaplet.dev/post/snaplet-is-shutting-downbit.io shut down https://blog.bit.io/whats-next-for-bit-io-joining-databricks-ace9a40bce0d?gi=8ef885454eefTimescale acquired PopSQL https://www.timescale.com/blog/best-postgresql-gui-popsql-joins-timescaleAiven https://aiven.ioHasura https://hasura.ioSupabase https://supabase.comNeon https://neon.techTembo https://tembo.ioFerretDB https://www.ferretdb.comHydra https://www.hydra.sopgEdge https://www.pgedge.comTembo raised $14m https://techcrunch.com/2024/07/08/database-startup-tembo-lands-new-cash-to-expandRy Walker's Cybertruck with STARTUP license plate https://x.com/rywalker/status/1810061804380557516 Supabase acquired OrioleDB https://supabase.com/blog/supabase-acquires-orioleMichael Stonebraker Turing Award Lecture https://www.youtube.com/watch?v=BbGeKi6T6QIMicrosoft acquired Citus https://blogs.microsoft.com/blog/2019/01/24/microsoft-acquires-citus-data-re-affirming-its-commitment-to-open-source-and-accelerating-azure-postgresql-performance-and-scaleCrunchy Bridge https://www.crunchydata.com/products/crunchy-bridgePeerDB https://www.peerdb.ioParadeDB https://www.paradedb.compganalyze https://pganalyze.comDBeaver https://dbeaver.ioPostico / Egger Apps https://eggerapps.at/postico2Postgres Compare https://www.postgrescompare.comCoroot https://coroot.comokmeter https://okmeter.ioSlides from Nikolay's talk on monitoring https://bit.ly/pg-monitoring Nile https://www.thenile.devUbicloud https://www.ubicloud.com~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
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 community together? How beneficial has it been to have a parallel chat while recording live? What is the “sweet spot” for the number of guests to have per episode? Is structure important for a podcast? Also discussed: this podcast's rename, a walk down memory lane reflecting on the past 16 episodes, and shout-outs to other podcasts about Postgres.Links mentioned in this episode:Cal invite for next Ep18 of Talking Postgres with David RowleyPodcast: Talking Postgres Talking Postgres Ep01: Working in public on open source with Simon Willison & Marco SlotEp02: How to get Postgres ready for the next 100 million usersEp03: Why giving talks at Postgres conferences matterswith Álvaro Herrera and Boriss MejíasVideo: Postgres Storytelling: What's going on with Synchronous Replication | POSETTE 2024 by Boriss MejíasVideo: Postgres Storytelling: Support in the Darkest Hour | Citus Con 2023, by Boriss MejíasEp04: How I got started as a dev and in Postgres with Melanie Plageman & Thomas MunroEp05: My favorite ways to learn more about PostgreSQL with Grant Fritchey & Ryan BoozVideo: Fibonacci Spirals and Ways to Contribute to Postgres—Beyond Code | Citus Con 2022, by Claire GiordanoEp06: You're probably already using Postgres with Chelsea Dole & Floor DreesWikipedia: Object–relational mappingVideo: How to work with other people | POSETTE 2024, by Floor Drees and Jimmy AngelakosEp07: Why people care about PostGIS and Postgres with Paul Ramsey & Regina ObeEp08: How I got started as a developer (& in Postgres) with Andres Freund & Heikki LinnakangasSatya Nadella's LinkedIn post about Andres Freund's xz backdoor discoveryEp09: Solving every data problem in SQL with Dimitri Fontaine & Vik FearingWikipedia: Advent of CodeEp10: My Journey into Postgres Monitoring with Lukas Fittl & Rob TreatEp11: My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco SlotEp12: From developer to PostgreSQL specialist with Derk van VeenEp13: Spinning up on Postgres & AI with Arda AytekinEp14: Becoming expert at using PostgreSQL with Chris EllisVideo: Electric Elephants | pgDay Paris 2024, by Chris EllisEp15: My Journey to Explaining Explain with Michael ChristofidesPodcast: Postgres FMEp16: The Making of POSETTE: An Event for Postgres with Teresa Giacomini & Aaron WislangPodcast: Scaling PostgreSQLPodcast: Postgres FM Ep99 with guest Claire Giordano: Sponsoring the communityPodcast: Hacking PostgresPlaylist: 5mins of Postgres
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 rename from Citus Con to POSETTE? Where did the inspiration for POSETTE come from? And can the hallway track at a conference actually be fun—if it is virtual? Also discussed: Avett Brothers lyrics, the surprising number of POSETTE speakers with chickens, and the existential question of whether the work in organizing a conference is worth it.Links mentioned in this episode: Blog post: What's in a name? About the naming of POSETTE: An Event for PostgresFOSDEM: the conference whose name inspired the POSETTE namePlaylist of all 42 talks from POSETTE: An Event for Postgres 2024Playlist of the 4 unique livestreams from POSETTE 2024 CFP is open: PGDay Lowlands 2024 Call for Papers will close July 9, 2024Virtual conference that POSETTE organizers were inspired by: P99 ConfDiscord: Microsoft Open Source Discord, Home for virtual hallway track for #posetteconfAdam Wølk's speaker page for POSETTESpeaker interview with Polina Bungina at POSETTEBlog post: About Talk Selection for POSETTE: An Event for Postgres 2024, by Claire GiordanoBlog post: Building the PGConf.dev Programme, by Paul RamseypgDay Paris 2024 note about talk selection processKeynote: All The Postgres Things at Microsoft, POSETTE edition, by Charles FeddersenKeynote: The Open Source Geospatial Community, PostGIS, & Postgres, by Regina ObeKeynote: Why I love open source development & what I learned from K8s, by Sarah NovotnyKeynote: A Walking Tour of PostgreSQL, by Thomas MunroLyrics from The Perfect Space by The Avett BrothersVideo: Lessons Learned benchmarking & profiling distributed PostgreSQL, by Lotte FeliusVideo: Postgres Storytelling: Support in the Darkest Hour | Citus Con 2023, by Boriss Mejías Video: Postgres Storytelling: What's going on with Synchronous Replication?, by Boriss MejíasVideo: Vindicating ZFS with PostgreSQL: Unleashing the Power of Scalability, includes a bit of jazz music by Federico CampoliBlog post: Ultimate Guide to POSETTE: An Event for Postgres, 2024 editionSocial post: Tweet by Kelsey Hightower with advice to conference organizersVideo from PGConfEU 2023: So you want a PGDay in your city, by Henrietta Dombrovskaya & Teresa GiacominiBlog post: The Story Behind the Activity Book for Postgres, by Teresa Giacomini
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) https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-s-new-with-postgres-at-microsoft-2024-edition/ba-p/4140085 Citus https://github.com/citusdata/citus Fibonacci Spirals and 21 Ways to Contribute to Postgres Beyond Code (talk by Claire) https://archive.fosdem.org/2020/schedule/event/postgresql_fibonacci_spirals_and_21_ways_to_contribute_to_postgres_beyond_code/ How to contribute to PostgreSQL or, 50 Ways To Love Your Project (talk slides by Josh Berkus) https://berkus.org/pdf_presos/50_ways.pdf pgconf dot dev https://2024.pgconf.dev/ POSETTE: An Event for Postgres https://www.citusdata.com/posette About Talk Selection for POSETTE https://www.citusdata.com/blog/2024/04/22/about-talk-selection-for-posette-an-event-for-postgres-2024/ Claire's video about how to say Postgres, PostgreSQL, Citus, and a few questionably named Microsoft things https://x.com/clairegiordano/status/1503784151614320640 Citus goes fully open source https://www.citusdata.com/blog/2024/04/22/about-talk-selection-for-posette-an-event-for-postgres-2024/Contributor Profiles https://www.postgresql.org/community/contributors/ Mastodon post by Álvaro Herrera (of EDB) https://lile.cl/@alvherre/112444579030481334 Path To Citus Con podcast (soon to be renamed to Talking Postgres) https://www.citusdata.com/podcast/path-to-citus-con/ ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
Did you know that sometimes the fastest way of doing something is not having to do it at all? In this episode of Path To Citus Con, the podcast for developers who love Postgres, Michael Christofides joins Claire Giordano to chat about his journey to explaining explain (or should we say EXPLAIN!?) Michael shared his origin story as a mathematician and his first experience with Postgres before walking us through co-founding a Postgres company and now co-hosting a podcast. Like many in the Postgres community, he is opinionated in the best way possible! We even learned about his passion for BUFFERS and why he believes everyone should use them. This session also dives into Michael's belief in the importance of Postgres documentation. Because great documentation can be worth its weight in Gold, especially when the going gets tough.Links mentioned in this episode:Schedule for POSETTE: An Event for Postgres 2024Michael Christofides' company, pgMustardBlog: Where our name came from by Michael ChristofidesWiki: Using EXPLAIN X: Nikolay SamokhvalovVideo: Lightning Talks at pgDay Paris 2024Blog: What's new with Postgres at Microsoft (August 2023) by Claire GiordanoBlog: Faster PostgreSQL Counting by Joe NelsonGitHub: pg_docs_bot (browser extension)GitHub Docs: About GitHub Copilot ChatDocumentation: Using EXPLAINGlossary: EXPLAIN Glossary by Michael ChristofidesVideo: EXPLAIN Explained by Josh BerkusBlog: Reading a Postgres EXPLAIN ANALYZE Query Plan by Caleb HearthBlog: Explaining the unexplainable by DepeszPostgreSQL execution plan visualizer, explain.dalibo.comBlog: Planet PostgreSQLNews: Postgres WeeklyPlaylist: 5mins of PostgresPodcast: Postgres FM podcastCal invite for next Ep16 of Path To Citus Con podcast with Aaron Wislang & Teresa Giacomini
Alongside his peers studying Systems Network Engineering, Jelte Fennema-Nio unearthed a security vulnerability within the framework of Postgres. Since then, Jelte joined the world of cybersecurity and network engineering. He is currently Principal Software Engineer at Microsoft working on Citus/ Postgres/ PgBouncer. In this episode we explore:Forking and the impact of commercial entities on the core project The challenges of connection poolingThe suitability of Citus for scalabilityThe intricacies of configuring PgBouncerPaying attention to community needs and modernizing contribution methodsLinks mentioned:Jelte on XJelte on LinkedIn
Būsto pardavėjai sako, kovas – geriausias per dvejus metus. Lietuvos bankas skaičiuoja, kad būstas šalyje tebėra pervertintas 5 proc. Norinčių ir galinčių pirkti, analitikas pastebi, yra daugiau, nei tą darančių – stabdo geopolitinė baimė. O tie, kas ieško ne pirmo būsto, dairosi ne tik Lietuvoje. Vis dėlto, kas nutiko, kad žmonės po stabtelėjimo vėl investuoja į nuosavą NT? Turi daugiau pinigų, nebegąsdina žinios apie karą, o gal būsto kainos – geros? Diskutuoja: Lietuvos banko Finansinio stabilumo departamento direktorius Jokūbas Markevičius, „Swedbank“ vyresnysis ekonomistas Vytenis Šimkus, „Realdata“ vadovas Arnoldas Antanavičius ir „Citus“ investicijų ir analizės vadovas Šarūnas Tarutis.Ved. Irma Janauskaitė
You have to find what works for you and Chris Ellis has never been the kind of person that could go and sit in a library—for Chris, the most productive Postgres place is in a coffee shop. In this episode of the Path To Citus Con podcast for developers who love Postgres, Chris Ellis joined Claire and Pino to chat about his path to becoming more (and more) expert at using PostgreSQL. Curiosity may have killed the cat but it's taken Chris places, beginning as a 5 year old playing with QBASIC. Chris shared his journey to becoming a developer, an electronic engineer, a builder, and a PostgreSQL user. This session also delves into Chris's work as a Postgres conference speaker (and organizer!) Importantly, we spent time remembering Simon Riggs, Postgres leader extraordinaire. RIP.Links mentioned in this episode:Chris's first thread on the PostgreSQL mailing listsSlides: IoT with PostgreSQL—by Chris Ellis at PGConf.EU 2023Slides: Advantage PostgreSQL—by Chris Ellis at Nordic PGDay 2024 Video: Should I use JSON in PostgreSQL?—by Boriss Mejías at PGConf.EU 2023 Slides: Fighting the Butterflies & giving your first Postgres conference talk—by Claire Giordano at pgDay Paris 2024 Markus Winand's website, Modern SQLWikipedia: Linus's lawAndres Freund's xz backdoor discoveryAndres Freund's Mastodon Toot about xz backdoorPodcast: Path to Citus Con Ep08: How I got started as a developer (& in Postgres) with Andres Freund & Heikki LinnakangasPodcast: Path To Citus Con Ep11: My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco SlotPodcast: Oxide and Friends next episode on Mon Apr 08 2024, featuring Andres Freund from MicrosoftJessie Frazelle tweet on LLMVideo of pgDay Paris 2024 lightning talks, including Chris's "Electric Elephants" talkPost about Simon Riggs's tragic passing last week. He will be missed, he is missed, and many are heartbroken Simon Riggs: The Next 20 Years—keynote at PGConf.EU 2023Book: The Art of PostgreSQL by Dimitri FontainePodcast: Path To Citus Con Ep09: Solving every data problem in SQL w/Dimitri Fontaine & Vik FearingBlog: Planet PostgreSQLBlog: Contributing to Postgres 101: A Beginner's Experience by Elizabeth Christensen Book: Linux Kernel Development by Robert Love Chris Ellis's LED PCB ArtBlog: pgDay Paris – Postgres Community, cheese and wine by Boriss MejíasPodcast: LUG RadioCFP for POSETTE: An Event for Postgres (free & virtual event) open until Sunday April 7th 2024 at 11:59pm PDTCal invite for next Ep15 of Path To Citus Con podcast with Michael Christofides
Everywhere you look, people are talking about AI. From Copilot to ChatGPT to Postgres's powerful AI capabilities (think: pgvector), AI is everywhere. In this episode of Path To Citus Con, for developers who love Postgres, Arda Aytekin joined Claire and Pino to chat about spinning up on Postgres and AI. Arda shared his origin story in mechanical engineering and data science before walking us through vector databases, pgvector, and azure_ai. Arda is one of the creators of the azure_ai extension, so the conversation delves into the azure_ai integration between Azure Database for PostgreSQL and Azure AI Services. Also discussed (of course) was—Responsible AI.Links mentioned in this episode:pgvector on GitHub: https://github.com/pgvector/pgvectorAndrew Kane: https://github.com/ankaneSimon Willison's Blog: https://simonwillison.net/Demo of Azure AI & pgvector with Azure Database for PostgreSQL by Claire Giordano: https://youtu.be/em0PKDGzzlQ?si=TrOQHXO5gqIuGsU0Blog: Introducing the azure_ai extension to Azure Database for PostgreSQL by Denzil Ribeiro: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/introducing-the-azure-ai-extension-to-azure-database-for/ba-p/3980291Documentation: Azure Database for PostgreSQL - Flexible Server Azure AI Extension: https://learn.microsoft.com/azure/postgresql/flexible-server/generative-ai-azure-overviewBlog: Vectors are the new JSON in PostgreSQL by Jonathan Katz: https://jkatz05.com/post/postgres/vectors-json-postgresql/Responsible AI at Microsoft: https://aka.ms/raiAndreessen's Corollary: Ethical Dilemmas in Software Engineering by Bryan Cantrill: https://www.youtube.com/watch?v=0wtvQZijPzgBlog: Phi-2: The surprising power of small language models by Mojan Javaheripi & Sébastien Bubeck: https://www.microsoft.com/research/blog/phi-2-the-surprising-power-of-small-language-models/pg_vectorize: https://github.com/tembo-io/pg_vectorizeOpenAI API documentation: https://platform.openai.com/docs/introductionMicrosoft Azure AI Fundamentals: Generative AI - Training: https://learn.microsoft.com/training/paths/introduction-generative-ai/ChatGPT Prompt Engineering for Developers: https://www.deeplearning.ai/short-courses/chatgpt-prompt-engineering-for-developers/Andrej Karpathy's keynote @ Microsoft Build 2023: https://www.youtube.com/watch?v=bZQun8Y4L2AStanford University CS231n: Deep Learning for Computer Vision: http://cs231n.stanford.edu/LangChain: https://www.langchain.com/Towards Data Science: https://towardsdatascience.com/Generative AI for Beginners on GitHub: https://github.com/microsoft/generative-ai-for-beginners/Zero-shot learning: https://en.wikipedia.org/wiki/Zero-shot_learningAndrej Karpathy thread on LLMs: https://www.threads.net/@karpathy/post/C3lBSlov1QJ/Podcast: Path to Citus Con Ep01: Working in public on open source with Simon Willison & Marco Slot: https://pathtocituscon.transistor.fm/episodes/working-in-public-on-open-sourceThe Art of PostgreSQL by Dimitri Fontaine, get 15% OFF with CLAIRE15: https://theartofpostgresql.com/Podcast: Path to Citus Con Ep08: Solving every data problem in SQL w/Dimitri Fontaine & Vik Fearing: https://pathtocituscon.transistor.fm/episodes/solving-every-data-problem-in-sql-w-dimitri-fontaine-vik-fearing)Arda Aytekin's scheduled talk at PGDay Chicago 2024 on April 26: https://postgresql.us/events/pgdaychicago2024/schedule/session/1542-learnings-from-extension-development-in-rust-pgrx/ CFP for POSETTE: An Event for Postgres (free & virtual event) open until April 7th 2024: https://aka.ms/posette-cfp-2024
Today's episode is with Craig Kerstiens, Craig has been in the Postgres space for a long time. First at Heroku, doing Heroku Postgres. Then at Citus, doing Distributed Postgres. Now at Crunchy Data, he's Chief Product Officer there. He's done a lot of Postgres advocacy and a lot of interesting stuff. In this episode we'll talk about the Postgres ecosystem, some of the Postgres features, some of the naysayers about Postgres, and just get Craig's thoughts on those.
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:Explaining the PostgreSQL concurrency control mechanisms by Derk van Veen: https://www.youtube.com/watch?v=SkxwaN46K88Podcast: Path to Citus Con Ep03: Why give talks at Postgres conferences with Álvaro Herrera & Boriss Mejías: https://pathtocituscon.transistor.fm/episodes/why-giving-talks-at-postgres-conferences-mattersBlog: A Deep Dive into Table Partitioning part 3 by Derk van Veen & Cosmin Octavian Pene: https://www.adyen.com/knowledge-hub/maintenance-under-pressureBook: On Writing: A Memoir of the Craft by Stephen King: https://stephenking.com/works/nonfiction/on-writing-a-memoir-of-the-craft.htmlPechaKucha, 20 slides for 20 seconds: https://en.wikipedia.org/wiki/PechaKuchapgChess: PostgreSQL 9.1+ extension for the game of Chess on GitHub: https://github.com/gciolli/pgChessFOSDEM PGDay 2023 talk by Derk van Veen: Fighting Write Amplification By Stimulating Hot Updates Through The Fill Factor: https://www.postgresql.eu/events/fosdem2023/schedule/session/4196-fighting-write-amplification-by-stimulating-hot-updates-through-the-fill-factor/Blog: Fighting PostgreSQL write amplification with HOT updates by Derk van Veen & Dave Pitts: https://www.adyen.com/knowledge-hub/postgresql-hot-updatesFOSDEM PGDay 2024 talk by Derk van Veen & Boriss Mejías: High Available Configurations Are Very Common For Postgresql. But How Do You Investigate Performance Problems When The Standby Can't Keep Up? 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/FOSDEM PGDay 2024 slides by Derk van Veen & Boriss Mejías: High Available Configurations Are Very Common For Postgresql. But How Do You Investigate Performance Problems When The Standby Can't Keep Up? https://www.postgresql.eu/events/fosdem2024/sessions/session/5164/slides/460/HA_delay_analysis.pdfX post with picture about Derk and Boriss' talk on FOSDEM PGDay 2024 by Devrim Gündüz: https://twitter.com/DevrimGunduz/status/1753348159026130959?s=20Blitz Chess game: https://www.chess.com/terms/blitz-chessCFP for POSETTE: An Event for Postgres (free & virtual event) open until April 7th 2024: https://aka.ms/posette-cfp-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:Podcast: Path To Citus Con Ep01: Working in public on open source with Simon Willison & Marco Slot: https://pathtocituscon.transistor.fm/episodes/working-in-public-on-open-sourceStreetlight effect: https://en.wikipedia.org/wiki/Streetlight_effectBenchBase: https://db.cs.cmu.edu/projects/benchbase/HammerDB: https://www.hammerdb.com/Slides: Intro to benchmarking with pgbench at PGConf NYC 2023 by Melanie Plageman: https://speakerdeck.com/melanieplageman/intro-to-benchmarking-with-pgbenchLocust: https://locust.io/Blog post: How to benchmark performance of Citus and Postgres with HammerDB on Azure by Jelte Fennema-Nio: https://www.citusdata.com/blog/2022/03/12/how-to-benchmark-performance-of-citus-and-postgres-with-hammerdb/Profiling with perf: https://wiki.postgresql.org/wiki/Profiling_with_perfFlame Graphs: https://www.brendangregg.com/flamegraphs.htmlBrendan Gregg's Website, a super-valuable resource for performance engineering: https://www.brendangregg.com/overview.htmlVideo: Analyzing Postgres performance problems using perf and eBPF by Andres Freund: https://www.youtube.com/watch?v=HghP4D72NocVideo: Explanatory talk about compiler optimization and memory & caches by Matt Godbolt: https://www.youtube.com/watch?v=4_smHyqgDTU&t=52sCompiler Explorer is fantastic, especially if you want to know how different compilers will optimize your code: https://godbolt.org/Mark Callaghan Twitter account @MarkCallaghanDB: https://twitter.com/MarkCallaghanDBPGConf.dev CFP is open until Mon Jan 15 2024 at 11:59pm PST: https://2024.pgconf.dev/cfp/3rd party performance benchmark in 2023 by GigaOM on Transaction Processing & Price-Performance Testing of Distributed SQL Databases: https://gigaom.com/report/transaction-processing-price-performance-testing/Blog post: "Query from any node" feature for Citus, by Marco Slot: https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/
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:OpenTelemetry: https://opentelemetry.io/pganalyze: https://pganalyze.com/pgDash: https://pgdash.io/pgMustard: https://www.pgmustard.com/pg_stat_statements docs: https://www.postgresql.org/docs/current/pgstatstatements.htmlpg_hint_plan: https://github.com/ossc-db/pg_hint_plan pg_hint_plan hint list: https://github.com/ossc-db/pg_hint_plan/blob/master/docs/hint_list.mdExample for PostgreSQL with pg_hint_plan: https://api.rubyonrails.org/classes/ActiveRecord/QueryMethods.html#method-i-optimizer_hints5mins of Postgres by pganalyze: https://www.youtube.com/playlist?list=PLhqxwIAgz78HZhWyu3UyKrCWNk7VWjVpjMonitoring page on PostgreSQL wiki: https://wiki.postgresql.org/wiki/MonitoringPgHero GitHub repo: https://github.com/ankane/pgheroInsights on pgBadger: A PGSQL Phriday #010 Recap: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/community-insights-on-pgbadger-a-pgsql-phriday-010-recap/ba-p/3880911Get PostgreSQL Logs Into Honeycomb: https://docs.honeycomb.io/getting-data-in/logs/postgresql/Blog post by Lukas Fittl about pg_stat_io by Lukas: https://pganalyze.com/blog/pg-stat-ioBlog post by Andrew Atkinson about pg_stat_io: https://andyatkinson.com/blog/2023/11/01/PostgreSQL-IO-Visibility-wehack-pg_stat_ioBPFtrace by iovisor GitHub repo: https://github.com/iovisor/bpftraceTrace PostgreSQL locks with pg_lock_tracer: https://jnidzwetzki.github.io/2023/01/11/trace-postgresql-locks-with-pg-lock-tracer.htmlsysdig by draios GitHub repo: https://github.com/draios/sysdigUsing BPFtrace to trace PostgreSQL vacuum operations: https://www.timescale.com/blog/using-bpftrace-to-trace-postgresql-vacuum-operations/PostgreSQL Mailing Lists: https://www.postgresql.org/list/psql — PostgreSQL interactive terminal: https://www.postgresql.org/docs/current/app-psql.htmlOngoing discussion thread about pg_stat_statements: https://commitfest.postgresql.org/46/2837/Reconnoiter project referenced by Rob: https://github.com/circonus-labs/reconnoiter/tree/master/sqlFunny tweet about PostgreSQL pronunciation: https://twitter.com/as_w/status/1648373353214885892O11ycast EP63 with Lukas Fittl: https://www.heavybit.com/library/podcasts/o11ycast/ep-63-observability-in-the-database-with-lukas-fittl-of-pganalyzeOxide and Friends podcast: https://oxide-and-friends.transistor.fm/
Nikolay and Michael discuss companion databases — when and why you might want to add another database management system to your stack (or not), and some specifics for analytics, timeseries, search, and vectors. Here are some links to things they mentioned:Heap were using Postgres + Citus for analytics as of 2022 https://www.heap.io/blog/juggling-state-machines-incident-response-and-data-soup-a-glimpse-into-heaps-engineering-culture Heap recently moved their core analytics to SingleStore (we only spotted this after recording
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:Dimitri Fontaine's blog: https://tapoueh.org/ Advent of Code: https://adventofcode.com/Dimitri's book, The Art of PostgreSQL: https://theartofpostgresql.com/ Blog post about What's new in SQL:2023: https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-newPostgreSQL Exercises at pgexercises.com: https://pgexercises.com/SQL Murder Mystery for learning SQL: https://mystery.knightlab.com/Pgvector extension for Postgres and AI embeddings: https://github.com/pgvector/pgvectorVik's Advent of Code puzzle solutions in SQL on GitHub: https://github.com/xocolatl/advent-of-codeStack Overflow data in Postgres, from pgtreats GitHub repo: https://github.com/pgtreats/stackoverflow_in_pgOpenStreetMap runs on Postgres: https://www.openstreetmap.org/#map=4/38.01/-95.84Uber data set: https://github.com/fivethirtyeight/uber-tlc-foil-responseIdeas for fun, open data sets: https://data.world/data-society?entryTypeLabel=dataset&tab=resources“Don't Do This” Timestamp learnings on PostgreSQL wiki: https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_timestamp_.28without_time_zone.29
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: Neon: https://neon.tech/ Rob Conery and Scott Hanselman's book: The Imposter's Handbook (https://twitter.com/shanselman/status/1610805353255677953) Path To Citus Con Ep04: https://pathtocituscon.transistor.fm/episodes/how-i-got-started-as-a-developer-in-postgres Andres' first patch to Postgres: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c43feefa806c81d68115ed03a7f723720cefad31 PGConf NYC 2023: https://2023.pgconf.nyc/ Flow book: https://www.google.com/books/edition/Flow/QVjPsd1UukEC Archives of Postgres hackers mailing list: https://www.postgresql.org/list/pgsql-hackers/ List of Postgres Contributors: https://www.postgresql.org/community/contributors/ Description of Postgres Core Team: https://www.postgresql.org/developer/core/ Postgres Weekly newsletter: https://postgresweekly.com/
Marco Slot spent nearly five years as lead engineer on Citus, an extension that turns Postgres into a distributed database. Citus Data was acquired by Microsoft in 2019, so these days Marco spends his time developing the Citus database engine which powers Azure Cosmos DB for PostgreSQL.
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:PostGIS: https://postgis.net/ FOSS4G NA: https://foss4gna.org/ Ushahidi: https://www.ushahidi.com/ Humanitarian Open Street Map: https://www.hotosm.org/ OpenStreetMap: https://www.openstreetmap.org/ pgRouting: https://pgrouting.org/ Regina Obe's books: https://locatepress.com/book/pgr Regina's book “PostGIS In Action”: https://www.manning.com/books/postgis-in-action-third-edition?experiment=B MobilityDB: https://github.com/MobilityDB/MobilityDB Blog: Analyzing GPS trajectories at scale with Postgres, PostGIS, MobilityDB, & Citus: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/analyzing-gps-trajectories-at-scale-with-postgres-mobilitydb-amp/ba-p/1859278 OSGeo: https://www.osgeo.org/ Simon Willison's presentation on "The weird world of LLMs": https://simonwillison.net/2023/Aug/3/weird-world-of-llms/ QGIS: https://qgis.org/en/site/ QGIS “Gentle Introduction” documentation: https://docs.qgis.org/3.28/en/docs/gentle_gis_introduction/ PostGIS Workshops: https://postgis.net/documentation/training/#workshop Locate Press: https://locatepress.com/ FedGeoDay 2023: https://www.fedgeo.us/about-2023 Schedule of FOSS4G NA 2023: https://foss4gna.org/schedule.html#schedule FOSS4G Brazil, December 2024: https://www.osgeo.org/foundation-news/foss4g-2024-has-been-awarded-to-belem-brazil/ Paul's keynote talk at PGConfEU in Lisbon in 2018, titled "Put some "where" in your WHERE clause": https://docs.google.com/presentation/d/1xyXA4-0wmNX7WfiLeH9h10bIkZxrej278-mMaClagys/edit?usp=sharing
Summary Data persistence is one of the most challenging aspects of computer systems. In the era of the cloud most developers rely on hosted services to manage their databases, but what if you are a cloud service? In this episode Vignesh Ravichandran explains how his team at Cloudflare provides PostgreSQL as a service to their developers for low latency and high uptime services at global scale. This is an interesting and insightful look at pragmatic engineering for reliability and scale. Announcements Hello and welcome to the Data Engineering Podcast, the show about modern data management Introducing RudderStack Profiles. RudderStack Profiles takes the SaaS guesswork and SQL grunt work out of building complete customer profiles so you can quickly ship actionable, enriched data to every downstream team. You specify the customer traits, then Profiles runs the joins and computations for you to create complete customer profiles. Get all of the details and try the new product today at dataengineeringpodcast.com/rudderstack (https://www.dataengineeringpodcast.com/rudderstack) This episode is brought to you by Datafold – a testing automation platform for data engineers that finds data quality issues before the code and data are deployed to production. Datafold leverages data-diffing to compare production and development environments and column-level lineage to show you the exact impact of every code change on data, metrics, and BI tools, keeping your team productive and stakeholders happy. Datafold integrates with dbt, the modern data stack, and seamlessly plugs in your data CI for team-wide and automated testing. If you are migrating to a modern data stack, Datafold can also help you automate data and code validation to speed up the migration. Learn more about Datafold by visiting dataengineeringpodcast.com/datafold (https://www.dataengineeringpodcast.com/datafold) You shouldn't have to throw away the database to build with fast-changing data. You should be able to keep the familiarity of SQL and the proven architecture of cloud warehouses, but swap the decades-old batch computation model for an efficient incremental engine to get complex queries that are always up-to-date. With Materialize, you can! It's the only true SQL streaming database built from the ground up to meet the needs of modern data products. Whether it's real-time dashboarding and analytics, personalization and segmentation or automation and alerting, Materialize gives you the ability to work with fresh, correct, and scalable results — all in a familiar SQL interface. Go to dataengineeringpodcast.com/materialize (https://www.dataengineeringpodcast.com/materialize) today to get 2 weeks free! Your host is Tobias Macey and today I'm interviewing Vignesh Ravichandran about building an internal database as a service platform at Cloudflare Interview Introduction How did you get involved in the area of data management? Can you start by describing the different database workloads that you have at Cloudflare? What are the different methods that you have used for managing database instances? What are the requirements and constraints that you had to account for in designing your current system? Why Postgres? optimizations for Postgres simplification from not supporting multiple engines limitations in postgres that make multi-tenancy challenging scale of operation (data volume, request rate What are the most interesting, innovative, or unexpected ways that you have seen your DBaaS used? What are the most interesting, unexpected, or challenging lessons that you have learned while working on your internal database platform? When is an internal database as a service the wrong choice? What do you have planned for the future of Postgres hosting at Cloudflare? Contact Info LinkedIn (https://www.linkedin.com/in/vigneshravichandran28/) Website (https://viggy28.dev/) Parting Question From your perspective, what is the biggest gap in the tooling or technology for data management today? Closing Announcements Thank you for listening! Don't forget to check out our other shows. Podcast.__init__ (https://www.pythonpodcast.com) covers the Python language, its community, and the innovative ways it is being used. The Machine Learning Podcast (https://www.themachinelearningpodcast.com) helps you go from idea to production with machine learning. Visit the site (https://www.dataengineeringpodcast.com) to subscribe to the show, sign up for the mailing list, and read the show notes. If you've learned something or tried out a project from the show then tell us about it! Email hosts@dataengineeringpodcast.com (mailto:hosts@dataengineeringpodcast.com)) with your story. To help other people find the show please leave a review on Apple Podcasts (https://podcasts.apple.com/us/podcast/data-engineering-podcast/id1193040557) and tell your friends and co-workers Links Cloudflare (https://www.cloudflare.com/) PostgreSQL (https://www.postgresql.org/) Podcast Episode (https://www.dataengineeringpodcast.com/postgresql-with-jonathan-katz-episode-42/) IP Address Data Type in Postgres (https://www.postgresql.org/docs/current/datatype-net-types.html) CockroachDB (https://www.cockroachlabs.com/) Podcast Episode (https://www.dataengineeringpodcast.com/cockroachdb-with-peter-mattis-episode-35/) Citus (https://www.citusdata.com/) Podcast Episode (https://www.dataengineeringpodcast.com/citus-data-with-ozgun-erdogan-and-craig-kerstiens-episode-13/) Yugabyte (https://www.yugabyte.com/) Podcast Episode (https://www.dataengineeringpodcast.com/yugabytedb-planet-scale-sql-episode-115/) Stolon (https://github.com/sorintlab/stolon) pg_rewind (https://www.postgresql.org/docs/current/app-pgrewind.html) PGBouncer (https://www.pgbouncer.org/) HAProxy Presentation (https://www.youtube.com/watch?v=HIOo4j-Tiq4) Etcd (https://etcd.io/) Patroni (https://patroni.readthedocs.io/en/latest/) pg_upgrade (https://www.postgresql.org/docs/current/pgupgrade.html) Edge Computing (https://en.wikipedia.org/wiki/Edge_computing) The intro and outro music is from The Hug (http://freemusicarchive.org/music/The_Freak_Fandango_Orchestra/Love_death_and_a_drunken_monkey/04_-_The_Hug) by The Freak Fandango Orchestra (http://freemusicarchive.org/music/The_Freak_Fandango_Orchestra/) / CC BY-SA (http://creativecommons.org/licenses/by-sa/3.0/)
Nikolay and Michael discuss sharding Postgres — what it means, why and when it's needed, and the available options right now. Here are some links to some things they mentioned:PGSQL Friday monthly blogging event https://www.pgsqlphriday.com/Did “sharding” come from Ultima Online? https://news.ycombinator.com/item?id=23438399 Our episode on partitioning: https://postgres.fm/episodes/partitioningVitess https://vitess.io/Citus https://www.citusdata.com/ Lessons learned from sharding Postgres (Notion 2021) https://www.notion.so/blog/sharding-postgres-at-notion The Great Re-shard (Notion 2023) https://www.notion.so/blog/the-great-re-shard The growing pains of database architecture (Figma 2023) https://www.figma.com/blog/how-figma-scaled-to-multiple-databases/Timescale multi-node https://docs.timescale.com/self-hosted/latest/multinode-timescaledb/about-multinode/ PgCat https://github.com/postgresml/pgcat SPQR https://github.com/pg-sharding/spqr PL/Proxy https://plproxy.github.io/ Sharding GitLab by top-level namespace https://about.gitlab.com/handbook/engineering/development/enablement/data_stores/database/doc/root-namespace-sharding.html Loose foreign keys (GitLab) https://docs.gitlab.com/ee/development/database/loose_foreign_keys.html ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork
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: Fintech startup where Chelsea works, Brex: https://www.brex.com/ Open source data platform where Floor works, Aiven: https://aiven.io/ “Mission-Critical PostgreSQL Databases on Kubernetes" by Karen Jex at KubeCon Europe 2023: https://www.youtube.com/watch?v=_NBQ9JmOMko The Imposters Handbook by Rob Conery: https://bigmachine.io/products/the-imposters-handbook/ Designing Data-Intensive Applications by Martin Kleppmann: https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/ Devopsdays Amsterdam: https://devopsdays.org/events/2023-amsterdam/welcome/ Building Community in Open Source with Floor Drees on the Last Week in AWS podcast: https://www.lastweekinaws.com/podcast/screaming-in-the-cloud/building-community-in-open-source-with-floor-drees/ pg_stat_statements: https://www.postgresql.org/docs/current/pgstatstatements.html PostGIS: https://postgis.net/ “Postgres tips for optimizing Django & Python performance, from my PyCon workshop” by Louise Grandjonc: https://www.citusdata.com/blog/2020/05/20/postgres-tips-for-django-and-python/ Video of Louise's PyCon talk, Optimize Django & Python performance with Postgres superpowers: https://youtu.be/dyBLGjCQJHsGrafana: https://grafana.com/pganalyze: https://pganalyze.com/ auto_explain: https://www.postgresql.org/docs/current/auto-explain.html EXPLAIN ANALYZE in PostgreSQL: https://www.postgresql.org/docs/current/sql-explain.html psql: https://www.postgresguide.com/utilities/psql/ Path To Citus Con Episode 05: My favorite ways to learn more about PostgreSQL with Grant Fritchey and Ryan Booz: https://pathtocituscon.transistor.fm/episodes/my-favorite-ways-to-learn-more-about-postgresql-with-grant-fritchey-and-ryan-booz Coffee Meets Bagel (dating app): https://coffeemeetsbagel.com/
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: Talk: Ryan's talk Point-in-time query tuning and observability with pg_stat_statements at Citus Con: An Event for Postgres 2022Blog: Learning PostgreSQL with Grant, a series for SQL Server devs learning about Postgres Podcast: postgres.fm, a weekly podcast about all things Postgres Podcast: Path To Citus Con Episode 01: Working in public on open sourceBlog aggregator: Planet PostgreSQL Email Newsletters: Cooperpress, including the Postgres Weekly email Podcast: Scaling PostgreSQL with Creston Jamison User Groups: PostgreSQL Community User Groups Videos: pganalyze "5 minutes of Postgres," by Lukas Fittl Book: The Art of PostgreSQL, by Dimitri Fontaine Book: PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya Book: SQL Performance Explained, by Markus Winand Blog: Modern SQL, by Markus WinandBlog: Use The Index, Luke, by Markus WinandBook: Database Administration, by Craig Mullins Book: A Curious Moon, by Rob Conery Book: The Little SQL Book, by Rob Conery, “Learn SQL While Watching Football This Weekend - Free!” Event: PGDay Chicago Blog: Redgate – Simple Talk Videos: CMU Database Group's Talks on YouTube: Quarantine (2020), First Dose (2021), Second Dose (2021), Booster (2022) Crunchy Data's Postgres Playground Blog: CYBERTEC Blog: Citus Open Source Blog Talk: How To Make Your Postgres Blog Posts Reach A Ton More People, by Claire GiordanoConference: PGCon 2023, super useful to watch recorded talks after the fact Conference: PGConf.EU, 2022, good example of an in-person event with lots of opportunities for learning Conference: Citus Con: An Event for Postgres 2023 Conference: PGConf NYC 2023 Blog Series: PGSQL Phriday, created by Ryan BoozBlog Series: PostgreSQL Person of the Week, by Andreas Scherbaum Blog: Robert Haas' blogBlog: select * from depesz;Book: PostgreSQL 14 internals, by Egor Rogov
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: Thomas' Citus Con talk Additional IO Observability in Postgres with pg_stat_io: Melanie's Citus Con talk Visualizing PostgreSQL I/O Performance for Development: Melanie's talk at PGCon 2023Add pg_stat_io view, providing more detailed IO statistics, committed by Melanie Plageman in PG 16 Neil deGrasse Tyson's podcast StarTalk From Nand to Tetris by Noam Nisan and Shimon Schocken Sinclair ZX81 All Things Open conference PostgreSQL BuildFarm Queues in PostgreSQL: Thomas' 2022 talk
Á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 Hour: Boriss' Citus Con talk A Curious Moon book by Rob Conery Tomas 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 by Gunnar "Nick" Bluth
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 Postgres: Melanie's talk at Citus Con 2023Optimizing Postgres for write heavy workloads ft. Checkpoint and WAL configs: Samay's talk at Citus Con 2023The Design of Postgres, by Michael Stonebraker and Lawrence A. Rowe, 1986 HyperLogLog PostGIS timescale/pgspot
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 - Claire's talk in 2022Big Opportunities in Small Data - Simon's keynote at Citus Con: An Event for PostgresThe Distributed PostgreSQL Problem and How Citus Solves It - Marco's keynote at Citus Con: An Event for Postgres
Nikolay and Michael discuss Postgres extensions — what they are, how they affect your decisions around Postgres, and some things to keep in mind when using them. Here are links to a few things we mentioned: Extensions (docs) https://www.postgresql.org/docs/current/external-extensions.html Extension (pgPedia) https://pgpedia.info/e/extension.html pgvector https://github.com/pgvector/pgvector PL/Rust https://github.com/tcdi/plrustZomboDB https://github.com/zombodb/zombodb Why is Postgres popular episode https://postgres.fm/episodes/why-is-postgres-popular Citus https://github.com/citusdata/citusTimescaleDB https://github.com/timescale/timescaledb OrioleDB https://github.com/orioledb/orioledbPostGIS https://trac.osgeo.org/postgis/ “There's an extension for that” (tweet from Robert Treat) https://twitter.com/robtreat2/status/1665735485883314178 RDS supported extensions https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html RUM https://github.com/postgrespro/rum pg_repack https://github.com/reorg/pg_repack PGXN https://pgxn.org/ pgTrunk by CoreDB https://pgtrunk.io/ Dbdev by Supabase https://supabase.com/blog/dbdev StackGres https://github.com/ongres/stackgrespg_tle by AWS https://github.com/aws/pg_tle Modern Postgres monitoring (slides from Nikolay's tutorial) https://twitter.com/samokhvalov/status/1664686535562625034 Awesome Postgres https://github.com/dhamaniasad/awesome-postgres ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!If you would like to share this episode, here's a good link (and thank you!)~~~Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork
Bulut tabanlı veritabanı platformu Citus Data'yı dünyaya açarak Bloomberg, Cisco ve Cloudflare gibi markaların tercih ettiği bir yapıya dönüştüren Umur, Microsoft'un teklifiyle şirketi 2019'da satıyor. Yolculuğun başında girişimci olarak girdiği Y-Combinator'a bu kez partner olarak dönerek “geri verme kültürü”ne katkıda bulunmayı tercih ediyor. Swipeline Podcast'in 160. bölümünde Citus Data'nın kurucu ortağı Umur Çubukçu konuğumuz. Umur Çubukçu: https://www.linkedin.com/in/umurc/ Citus Data: https://www.citusdata.com/
In this episode of Hospice News Elevate, sponsored by CITUS Health, editor Jim Parker speaks with Jackie Owen, a registered nurse and Clinical Product Specialist for CITUS , about the importance of patient and family engagement.
In this episode of Scaling Postgres, we discuss WAL growing to 11 Terabytes, pgec supporting writes, Patroni 3.0 & Citus for high availability, and setting up PostgREST. Visit https://www.scalingpostgres.com/episodes/255-integer-overflow-user-friendly-permissions-dump-logical-replication-worker-config/ to get the show notes as well as subscribe to get notified of new episodes.
Nikolay and Michael discuss real-time analytics — what it means, what the options are, and some tips if you're trying to implement it within Postgres. Here are links to a few things we mentioned: Loose index scan / skip scan with recursive CTE (wiki)Zheap (wiki)cstore_fdw (now part of Citus)Timescale compression docsHydra founders interview (on Postgres TV)Materialised views episode pg_ivmTimescale continuous aggregates docsClickhouseSnowflakeReplication episodeTimescale bottomless storage on S3 (blog post)pg_partmanQuerying Postgres from DuckDB (blog post)Heap blog (filter by “Engineering”)Incremental View Maintenance (wiki)PostgreSQL HyperLogLog Faster counting (by Joe Nelson on the Citus blog)------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.If you would like to share this episode, here's a good link (and thank you!)Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork
In this episode of Scaling Postgres, we discuss using rust for Postgres extensions, performance comparisons of TimescaleDB vs. Postgres, uninterrupted writes when sharding in Citus and the Postgres data flow. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://postgresml.org/blog/postgresml-is-moving-to-rust-for-our-2.0-release/ https://www.timescale.com/blog/postgresql-timescaledb-1000x-faster-queries-90-data-compression-and-much-more/ https://www.citusdata.com/blog/2022/09/19/citus-11-1-shards-postgres-tables-without-interruption/ https://www.crunchydata.com/blog/postgres-data-flow https://www.cybertec-postgresql.com/en/postgresql-sequences-vs-invoice-numbers/ https://postgrespro.com/blog/pgsql/5969741 https://www.crunchydata.com/blog/fun-with-postgres-functions https://www.depesz.com/2022/09/18/what-is-lateral-what-is-it-for-and-how-can-one-use-it/ https://www.postgresql.fastware.com/blog/column-lists-in-logical-replication-publications https://blog.dalibo.com/2022/09/19/psycopg-pipeline-mode.html https://pganalyze.com/blog/5mins-postgres-python-psycopg-3-1-pipeline-mode-query-performance https://ideia.me/using-the-timescale-gem-with-ruby https://b-peng.blogspot.com/2022/09/configuring-vip-route-table.html https://postgres.fm/episodes/index-maintenance https://postgresql.life/post/peter_smith/ https://www.rubberduckdevshow.com/episodes/59-rails-postgres-scaling-with-andrew-atkinson/
In this episode of Scaling Postgres, we discuss a PG 14.4 release, how to skip transactions with logical replication, how to use schemas and Citus going fully open source. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-144-released-2470/ https://www.postgresql.fastware.com/blog/addressing-replication-conflicts-using-alter-subscription-skip https://aaronoellis.com/articles/using-postgres-schemas https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/ https://www.cybertec-postgresql.com/en/case-insensitive-pattern-matching-in-postgresql/ https://blog.brendanscullion.com/postgresql-text-search https://www.crunchydata.com/blog/quick-and-easy-postgres-data-compare https://sqlfordevs.io/uuid-prevent-enumeration-attack https://andreas.scherbaum.la/blog/archives/1113-My-PostgreSQL-database-is-empty!.html https://pganalyze.com/blog/5mins-postgres-reducing-aws-aurora-io-costs-table-partitioning-pruning https://www.migops.com/blog/oracle-vs-postgresql-transaction-control-statements/ https://aws.amazon.com/blogs/database/handle-empty-strings-when-migrating-from-oracle-to-postgresql/ https://postgresql.life/post/vigneshwaran_c/ https://www.rubberduckdevshow.com/episodes/46-ractors-actors-for-ruby/
Claire Giordano joins Scott Hanselman to show how the new Free account for Flexible Server & the new Basic tier for Hyperscale (Citus) in Azure Database for PostgreSQL makes it easier and cheaper to get started with Postgres on Azure.[0:00:00]– Introduction[0:01:15]– What you might not know about Postgres on Azure[0:02:50]– Flexible Server available in Azure free account[0:04:00]– Getting started with Hyperscale (Citus)[0:09:05]– Demo: Hyperscale (Citus)[0:18:20]– Wrap-upFlexible Server (Preview) documentationTutorial: Deploy Django app with App Service and Azure Database for PostgreSQL - Flexible Server (Preview)DEMO: 3 Hyperscale (Citus) superpowers to scale PostgreSQL (YouTube)Citus (PostgreSQL extension) GitHub repoAzure Database for PostgreSQL - Hyperscale (Citus) documentationNew Postgres superpowers in Hyperscale (Citus) with Citus 10Sharding Postgres with Basic tier in Hyperscale (Citus), how why & whenMicrosoft Learn: Introduction to Azure Database for PostgreSQLIntroducing Flexible Server in Azure Database for PostgreSQL & MySQL (Ch 9)How do you pronounce Citus?Create a free account (Azure)