Log in

goodpods headphones icon

To access all our features

Open the Goodpods app
Close icon
headphones
Hacking Postgres

Hacking Postgres

Ry Walker

All about extensions, extension creators, and people doing cool things with Postgres. New episodes every week.
bookmark
Share icon

All episodes

Best episodes

Top 10 Hacking Postgres Episodes

Goodpods has curated a list of the 10 best Hacking Postgres episodes, ranked by the number of listens and likes each episode have garnered from our listeners. If you are listening to Hacking Postgres for the first time, there's no better place to start than with one of these standout episodes. If you are a fan of the show, vote for your favorite Hacking Postgres episode by adding your comments to the episode page.

Hacking Postgres - S1E1: Marco Slot, Citus Data, Microsoft
play

10/02/23 • 30 min

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.

bookmark
plus icon
share episode
Hacking Postgres - S1E4: Pavlo Golub, Cybertec, pg_timetable
play

10/13/23 • 24 min

Pavlo Golub is the Co-Founder of PostgreSQL Ukraine and a PostgreSQL expert at Cybertec. Pavlo created pg_timetable, an advanced standalone job scheduler for Postgres.

bookmark
plus icon
share episode
Hacking Postgres - S3E1: Francesco Tisiot, Field CTO Aiven
play

10/22/24 • 31 min

Joining Aiven in 2021, Francesco Tisiot works as a Field CTO and AI Lead. He serves as a technical advisor to clients and prospects, helping to meet their needs without the focus on sales, acting as a 'rented' CTO to provide expert guidance. Join us as we dive into Francesco's insightful perspectives on the Postgres community, where he challenges the notion of valuing years of experience over actual contributions and expertise.

In this episode, we explore:

  • How Postgres is a core focus for Aiven
  • Strategies for incorporating diverse viewpoints within the community
  • The perception of Oracle within the Postgres community
  • Benefits and challenges of using AI tools for database optimisation
  • Acquisition of EverSQL by Aiven for integrating AI tools in SQL performance tuning

Links mentioned:

Aiven for AlloyDB Omni

Francesco Tisiot on X

Francesco Tisiot on LinkedIn

bookmark
plus icon
share episode
Hacking Postgres - S2E10: DJ Patil and Ray Lane, GreatPoint Ventures
play

07/03/24 • 44 min

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

Tune in as they share their experiences with early databases such as Db2, the rise of Postgres, and current challenges in the tech landscape. With insights on leadership, community-driven development, and more, this episode is a must-listen for developers, entrepreneurs, and tech enthusiasts.

In this episode, we explore:

  • The critical need for evolving roles within a company to foster growth
  • Challenges of data distribution vs. keeping data centralized and speedy
  • “Siding with the community” and enhancing user capabilities
  • The risks of rushing towards generative AI, and the importance data hygiene and data culture

Links mentioned:

GreatPoint Ventures

DJ Patil on LinkedIn

Ray Lane on LinkedIn

bookmark
plus icon
share episode
Hacking Postgres - S2E9: Sai Srirampur, PeerDB
play

05/30/24 • 41 min

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

bookmark
plus icon
share episode
Hacking Postgres - S2E8: Melanie Plageman, Microsoft
play

05/23/24 • 36 min

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

@[email protected]

Melanie on X (@melanieplageman)

bookmark
plus icon
share episode
Hacking Postgres - S2E7: Bharath Rupireddy, AWS
play

05/16/24 • 30 min

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

bookmark
plus icon
share episode
Hacking Postgres - S1E3: Eric Ridge, ZomboDB, pgrx, plrust
play

10/06/23 • 20 min

Eric Ridge is the primary developer of ZomboDB, “Making Postgres and Elasticsearch work together like it's 2023.” He’s also an active part of the pgrx and plrust teams.

bookmark
plus icon
share episode
Hacking Postgres - S2E6: Gülçin Yıldırım Jelínek, EDB
play

05/09/24 • 37 min

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

bookmark
plus icon
share episode
Hacking Postgres - S3E2: Heikki Linnakangas, Cofounder Neon
play

11/12/24 • 27 min

Today we take a deep dive into the world of PostgreSQL extensions, featuring our conversation with Heikki Linnakangas, co-founder of Neon, an expert Postgres hacker, and contributor to pgvector. Heikki shares the fascinating story of how Neon was born in 2021, driven by the vision of creating an open-source platform akin to Aurora Serverless. He delves into the early challenges and triumphs of building a fully remote startup during pandemic times, including the excitement of growing from a handful of employees to a bustling company with 600,000 databases under management.

In this episode, we explore:

  • From a startup idea to managing over 600K databases
  • Building a remote-first culture and the power of annual off-site meetings
  • Time travel... how Neon's unique storage system enables quick point-in-time recovery
  • Upcoming Postgres features like asynchronous IO and multi-threading
  • How understanding new algorithms can help database management

Links mentioned:

Neon

Heikki Linnakangas on GitHub

Heikki Linnakangas on LinkedIn

bookmark
plus icon
share episode

Show more best episodes

Toggle view more icon

FAQ

How many episodes does Hacking Postgres have?

Hacking Postgres currently has 22 episodes available.

What topics does Hacking Postgres cover?

The podcast is about Entrepreneurship, Software Development, Podcasts, Technology and Business.

What is the most popular episode on Hacking Postgres?

The episode title 'S2E8: Melanie Plageman, Microsoft' is the most popular.

What is the average episode length on Hacking Postgres?

The average episode length on Hacking Postgres is 34 minutes.

How often are episodes of Hacking Postgres released?

Episodes of Hacking Postgres are typically released every 7 days.

When was the first episode of Hacking Postgres?

The first episode of Hacking Postgres was released on Oct 2, 2023.

Show more FAQ

Toggle view more icon

Comments