• S2E9: Sai Srirampur, PeerDB
    May 30 2024

    Sai Srirampur is the co-founder of PeerDB and a veteran Postgres Solutions Engineer with experience at Citus Data and Microsoft. He has been at the forefront of optimizing and scaling Postgres for large data workloads and is now spearheading innovation in data movement and replication with PeerDB. In this episode, we'll discuss the challenges of tuning massive Postgres systems, real-time data streaming solutions, and PeerDB’s vision for the future.


    In this episode we explore:

    • Leaving Microsoft and starting Sai’s own company, PeerDB
    • Developing PeerDB's data movement and replication tool
    • Why Postgres might not be suitable for everything at a large scale
    • Having team members be database experts first before being software developers
    • The growing customer demand for Clickhouse and Snowflake

    Links mentioned:

    PeerDB

    Sai Srirampur on X (@saisrirampur)

    Sai Srirampur on LinkedIn

    Show more Show less
    42 mins
  • S2E8: Melanie Plageman, Microsoft
    May 23 2024

    In this episode, we talk Postgres committer Melanie Plagemean about her involvement with @PGConfdev, improvements to vacuum scheduling and auto vacuum configuration, the logical replication of DDL, and platforms such as CNCF and Kubernetes integrating with Postgres.


    Links mentioned:

    PGConf.dev

    YouTube – CMU Database Group

    Path To Citus Con Podcast

    @melanieplageman@mastodon.social

    Melanie on X (@melanieplageman)

    Show more Show less
    37 mins
  • S2E7: Bharath Rupireddy, AWS
    May 16 2024

    Bharath Rupireddy has carved a niche for himself in the Postgres community since he began using the database system back in 2020. From his start at EnterpriseDB to making strides at Microsoft, and now contributing to the AWS open-source project, Bharath is entrenched in the inner workings of Postgres development. He has worked in many areas of Postgres such as WAL, Replication, pg_walinspect extension, bug fixes, performance improvements, new SQL functions etc.


    In this episode we explore:

    • Starting with Postgres in 2020 and learning the basics while contributing to Parallel COPY feature
    • Postgres recent features such as pg_walinspect extension, WAL source switch from archive to streaming, WAL insertion lock improvements, WAL read from buffers, more replication slot invalidation mechanisms like XID age based and inactive_timeout based ones, new table access methods for multi inserts.
    • The future of native active-active replication
    • The complexities of conflict resolution
    • Using PostgreSQL 16 in production scenarios for active-active replication
    • The role of databases evolving within different industries

    Links mentioned:

    ¡Databases! – A Database Seminar Series

    Hacking Postgres, Ep. 9: Bertrand Drouvot

    PGConf India

    Hyderabad PostgreSQL User Group

    PGConf.dev

    Bharath on LinkedIn

    Bharath on X (@BRupireddy)

    Bharath on Github

    Show more Show less
    30 mins
  • S2E6: Gülçin Yıldırım Jelínek, EDB
    May 9 2024

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


    In this episode we explore:

    • CloudNativePG in Gülçin’s products and the new SPGVector release
    • Welcoming new developers to the PostgreSQL community
    • Tembo Cloud, PG vector, and the challenges and rewards of contributing to such innovative projects
    • Improving inclusivity and support for women in the tech industry
    • The use of Postgres in AI workloads


    Links mentioned:

    The Builders: A Postgres Podcast

    Gülçin Yıldırım Jelínek on X

    EDB

    Postgres Women on X

    Show more Show less
    37 mins
  • S2E5: Jelte Fennema-Nio, Principal Software Engineer, Microsoft
    May 2 2024

    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 pooling
    • The suitability of Citus for scalability
    • The intricacies of configuring PgBouncer
    • Paying attention to community needs and modernizing contribution methods

    Links mentioned:

    Jelte on X

    Jelte on LinkedIn

    Show more Show less
    32 mins
  • S2E4: Amit Kapila, Fujitsu India
    Apr 25 2024

    Amit Kapila is a PostgreSQL Committer and a Senior Director at Fujitsu India. Amit joins the show to share his contributions to logical replication enhancements (achieving highly available systems), his involvement in the PostgreSQL community, and his perspective on contributions from tech giants in advancing PostgreSQL features.

    In this episode we explore:

    • Amit’s early work with PostgreSQL and Oracle
    • The future of active-active topology
    • The dependence on managed services for database management
    • The importance of conflict resolution in replication
    • Overcoming the lack of an open-source development environment in India

    Links mentioned:

    pgsql-hackers

    Amit Kapila on LinkedIn

    Amit Kapila on X (@kapila_amit)

    Amit’s Blog

    Show more Show less
    34 mins
  • S2E3: David Wheeler, Principal Architect, Tembo
    Apr 18 2024

    As Principal Architect at Tembo and the creator of PGXN, David Wheeler is a seminal figure in the Postgres world. Join us as we discuss David's tenure at The New York Times, his influential projects like Bricolage and pgTAP, and the game-changing database change management system, Sqitch.


    In this episode we explore:

    • David Wheeler's transition from archaeology to databases
    • Database management and learning with Sqitch
    • Working with PGXN and Tembo
    • Creating a central registry for Postgres extensions
    • The state of Postgres and its versatility


    Links mentioned:

    pgTAP

    PGXN

    CITEXT 2

    Sqitch

    Better Call Saul Insider Podcast

    Scriptnotes

    theory@xoxo.zone

    Just a Theory

    Show more Show less
    39 mins
  • S2E2: Denis Magda, Director of Developer Relations, Yugabyte
    Apr 11 2024

    Denis Magda is the mastermind behind the innovative extension PgCompute and a pivotal figure in the world of Postgres development. With over a decade and a half of experience, Denis cut his teeth on Postgres during its use in high-traffic social networking projects in Eastern Europe and has continued to push the envelope at Yugabyte as the head of Developer Relations.


    In this episode we explore:

    • The role of Yugabyte in the Postgres ecosystem
    • The need for local development experiences
    • A more 'magical' and testing-friendly approach to handling stored procedures
    • The intersection of DevRel with sales engineering and marketing
    • The future of Postgres in educational institutions

    Links mentioned:

    Business Wars podcast

    Postgres FM

    Founders podcast

    Denis on X

    Denis on LinkedIn

    Yugabyte

    Show more Show less
    48 mins