Hacking Postgres Transistor (https://transistor.fm) https://feeds.transistor.fm/hacking-postgres All about extensions, extension creators, and people doing cool things with Postgres. New episodes every week. © 2023 Tembo Data Systems, Inc. bc9933ad-3dc3-5043-8214-50cf5501493d no en Tue, 12 Nov 2024 09:00:05 -0500 Tue, 02 Dec 2025 21:45:07 -0500 https://twitter.com/tembo_io https://img.transistor.fm/S2e0kr6EPiFcDc5nYuLkee8_I42yu19U5-1cuzka2TQ/rs:fill:0:0:1/w:1400/h:1400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzQ1NjA5LzE2OTU5/NDUwOTgtYXJ0d29y/ay5qcGc.jpg Hacking Postgres https://twitter.com/tembo_io episodic Ry Walker All about extensions, extension creators, and people doing cool things with Postgres. New episodes every week. All about extensions, extension creators, and people doing cool things with Postgres. Postgres, Extensions, Software Development Ry Walker ry@tembo.io No No S3E2: Heikki Linnakangas, Cofounder Neon 22 22 S3E2: Heikki Linnakangas, Cofounder Neon full 166bf8d2-f37f-4a15-9270-d2ce0ca9e0ad https://share.transistor.fm/s/d1d7be9d 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

]]> 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

]]> Tue, 12 Nov 2024 09:00:00 -0500 Ry Walker Ry Walker 1620 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

]]> Postgres, Extensions, Software Development No S3E1: Francesco Tisiot, Field CTO Aiven 21 21 S3E1: Francesco Tisiot, Field CTO Aiven full 7ed55b63-a25f-427a-a434-03c92426274f https://share.transistor.fm/s/d3544a18 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

]]> 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

]]> Tue, 22 Oct 2024 11:24:42 -0400 Ry Walker Ry Walker 1906 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

]]> Postgres, Extensions, Software Development No S2E10: DJ Patil and Ray Lane, GreatPoint Ventures 20 20 S2E10: DJ Patil and Ray Lane, GreatPoint Ventures full 39c50e85-0b7a-42c3-a802-03a9f73f8d26 https://share.transistor.fm/s/38de3599 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


]]> 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


]]> Wed, 03 Jul 2024 12:00:00 -0400 Ry Walker Ry Walker 2658 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


]]> Postgres, Extensions, Software Development No S2E9: Sai Srirampur, PeerDB 19 19 S2E9: Sai Srirampur, PeerDB full a3065f01-2f2b-4dd3-aaeb-fc1882aa8618 https://share.transistor.fm/s/cdb93d27 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

]]> 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

]]> Thu, 30 May 2024 09:00:00 -0400 Ry Walker Ry Walker 2497 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

]]> Postgres, Extensions, Software Development No S2E8: Melanie Plageman, Microsoft 18 18 S2E8: Melanie Plageman, Microsoft full 621a099c-c325-41d3-9060-2c3e2de7a043 https://share.transistor.fm/s/44499ada 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)

]]> 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)

]]> Thu, 23 May 2024 09:00:00 -0400 Ry Walker Ry Walker 2215 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)

]]> Postgres, Extensions, Software Development No S2E7: Bharath Rupireddy, AWS 17 17 S2E7: Bharath Rupireddy, AWS full c7566662-876b-466a-be43-fac21b69ddf1 https://share.transistor.fm/s/a8f30775 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

]]> 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

]]> Thu, 16 May 2024 09:00:00 -0400 Ry Walker Ry Walker 1808 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

]]> Postgres, Extensions, Software Development No S2E6: Gülçin Yıldırım Jelínek, EDB 16 16 S2E6: Gülçin Yıldırım Jelínek, EDB full bf69c919-1b04-4ff1-9300-76e38bb212ff https://share.transistor.fm/s/33c0ce5b 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

]]> 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

]]> Thu, 09 May 2024 09:00:00 -0400 Ry Walker Ry Walker 2229 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

]]> Postgres, Extensions, Software Development No S2E5: Jelte Fennema-Nio, Principal Software Engineer, Microsoft 15 15 S2E5: Jelte Fennema-Nio, Principal Software Engineer, Microsoft full 35f3e002-d3d5-4533-ab81-a1406c06d407 https://share.transistor.fm/s/c8efa540 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

]]> 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

]]> Thu, 02 May 2024 09:00:00 -0400 Ry Walker Ry Walker 1900 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

]]> Postgres, Extensions, Software Development No S2E4: Amit Kapila, Fujitsu India 14 14 S2E4: Amit Kapila, Fujitsu India full 1e725177-b912-4e77-88b1-f81ec5ae5c90 https://share.transistor.fm/s/2dc636e7 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

]]> 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

]]> Thu, 25 Apr 2024 09:00:00 -0400 Ry Walker Ry Walker 2062 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

]]> Postgres, Extensions, Software Development No S2E3: David Wheeler, Principal Architect, Tembo 13 13 S2E3: David Wheeler, Principal Architect, Tembo full e291e274-93c7-473e-9caa-2e828725962f https://share.transistor.fm/s/3d68b57b 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

]]> 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

]]> Thu, 18 Apr 2024 09:00:00 -0400 Ry Walker Ry Walker 2315 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

]]> Postgres, Extensions, Software Development No S2E2: Denis Magda, Director of Developer Relations, Yugabyte 12 12 S2E2: Denis Magda, Director of Developer Relations, Yugabyte full 4404a1b4-2289-49c1-9792-8c5b4c60ca5e https://share.transistor.fm/s/c51d12de 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

]]> 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

]]> Thu, 11 Apr 2024 09:00:00 -0400 Ry Walker Ry Walker 2903 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

]]> Postgres, Extensions, Software Development No S2E1: Andrew Atkinson, Software Engineer and Author 11 11 S2E1: Andrew Atkinson, Software Engineer and Author full e6f7c034-2c40-4fd9-8417-f415bff23564 https://share.transistor.fm/s/6dc673af Andrew Atkinson is a Software Engineer who specializes in building high-performance web applications using PostgreSQL and Ruby on Rails. He wrote the book ‘High-Performance PostgreSQL for Rails’, published by Pragmatic Programmers in 2024.


Our discussion with Andrew spans the technical challenges of sharding and the concurrent evolution of Rails and Postgres. We'll pay homage to influential resources like Railscast, debate Rails' database tooling limitations, and discover tips from Andrew's new book.


In this episode we explore:

  • Why newer developers favor Postgres over MySQL
  • How Postgres might become a multi-primary database in the future
  • The complexities of database decisions in a Rails environment
  • Postgres innovations, such as composite primary keys and common table expressions, being supported from Active Record – the ORM for Ruby on Rails
  • Key insights from writing ‘High Performance PostgreSQL for Rails’

Links mentioned:

Andrew Atkinson on LinkedIn

Andrew’s Blog

Newsletter

PGCasts

RailsCasts

‘High Performance PostgreSQL for Rails’ by Andrew Atkinson

Github rideshare

Postgres FM

Andrew Aktkinson’s interview on Postgres FM

Andrew Atkinson’s interview on Remote Ruby

Remote Ruby Podcast

GitHub doc: clarify logical decoding's deadlock of system tables

GitHub doc: Doc: fix grammatical errors for enable_partitionwise_aggregate 

GitHub Convert README to Markdown

]]> Andrew Atkinson is a Software Engineer who specializes in building high-performance web applications using PostgreSQL and Ruby on Rails. He wrote the book ‘High-Performance PostgreSQL for Rails’, published by Pragmatic Programmers in 2024.


Our discussion with Andrew spans the technical challenges of sharding and the concurrent evolution of Rails and Postgres. We'll pay homage to influential resources like Railscast, debate Rails' database tooling limitations, and discover tips from Andrew's new book.


In this episode we explore:

  • Why newer developers favor Postgres over MySQL
  • How Postgres might become a multi-primary database in the future
  • The complexities of database decisions in a Rails environment
  • Postgres innovations, such as composite primary keys and common table expressions, being supported from Active Record – the ORM for Ruby on Rails
  • Key insights from writing ‘High Performance PostgreSQL for Rails’

Links mentioned:

Andrew Atkinson on LinkedIn

Andrew’s Blog

Newsletter

PGCasts

RailsCasts

‘High Performance PostgreSQL for Rails’ by Andrew Atkinson

Github rideshare

Postgres FM

Andrew Aktkinson’s interview on Postgres FM

Andrew Atkinson’s interview on Remote Ruby

Remote Ruby Podcast

GitHub doc: clarify logical decoding's deadlock of system tables

GitHub doc: Doc: fix grammatical errors for enable_partitionwise_aggregate 

GitHub Convert README to Markdown

]]> Thu, 04 Apr 2024 18:11:45 -0400 Ry Walker Ry Walker 2132 Andrew Atkinson is a Software Engineer who specializes in building high-performance web applications using PostgreSQL and Ruby on Rails. He wrote the book ‘High-Performance PostgreSQL for Rails’, published by Pragmatic Programmers in 2024.


Our discussion with Andrew spans the technical challenges of sharding and the concurrent evolution of Rails and Postgres. We'll pay homage to influential resources like Railscast, debate Rails' database tooling limitations, and discover tips from Andrew's new book.


In this episode we explore:

  • Why newer developers favor Postgres over MySQL
  • How Postgres might become a multi-primary database in the future
  • The complexities of database decisions in a Rails environment
  • Postgres innovations, such as composite primary keys and common table expressions, being supported from Active Record – the ORM for Ruby on Rails
  • Key insights from writing ‘High Performance PostgreSQL for Rails’

Links mentioned:

Andrew Atkinson on LinkedIn

Andrew’s Blog

Newsletter

PGCasts

RailsCasts

‘High Performance PostgreSQL for Rails’ by Andrew Atkinson

Github rideshare

Postgres FM

Andrew Aktkinson’s interview on Postgres FM

Andrew Atkinson’s interview on Remote Ruby

Remote Ruby Podcast

GitHub doc: clarify logical decoding's deadlock of system tables

GitHub doc: Doc: fix grammatical errors for enable_partitionwise_aggregate 

GitHub Convert README to Markdown

]]> Postgres, Extensions, Software Development No S1E10: Tim Sehn, Dolthub, Doltgres 10 10 S1E10: Tim Sehn, Dolthub, Doltgres full d34fdde5-4edf-4e50-b0f0-b71cbe8ec34a https://share.transistor.fm/s/f582d3ba Just describing something truly novel is challenging, let alone building it. That’s the story of our final episode from Season 1, where Ry sits down with Tim Sehn from Dolthub to talk about the journey of building Dolt, the new release of Doltgres, and the challenges of adapting to the changing ways users engage with your product. 


]]> Just describing something truly novel is challenging, let alone building it. That’s the story of our final episode from Season 1, where Ry sits down with Tim Sehn from Dolthub to talk about the journey of building Dolt, the new release of Doltgres, and the challenges of adapting to the changing ways users engage with your product. 


]]> Fri, 01 Dec 2023 09:00:00 -0500 Ry Walker Ry Walker 2070 Just describing something truly novel is challenging, let alone building it. That’s the story of our final episode from Season 1, where Ry sits down with Tim Sehn from Dolthub to talk about the journey of building Dolt, the new release of Doltgres, and the challenges of adapting to the changing ways users engage with your product. 


]]> Postgres, Extensions, Software Development No S1E9: Bertrand Drouvot, AWS Cloud, pgsentinel 9 9 S1E9: Bertrand Drouvot, AWS Cloud, pgsentinel full c7b0954d-c6f6-4c9a-972d-dfbca0b756d8 https://share.transistor.fm/s/573aa44a Build the thing you wish you had right now. That’s the story behind Hacking Postgres, Ep 9, where Ry sits down with Bertrand Drouvot of AWS Cloud. Today they talked about the struggles of trying to build from scratch vs having a template, what should be core vs an extension, and being able to see what’s really happening inside your database. 


]]> Build the thing you wish you had right now. That’s the story behind Hacking Postgres, Ep 9, where Ry sits down with Bertrand Drouvot of AWS Cloud. Today they talked about the struggles of trying to build from scratch vs having a template, what should be core vs an extension, and being able to see what’s really happening inside your database. 


]]> Fri, 17 Nov 2023 09:00:00 -0500 Ry Walker Ry Walker 2033 Build the thing you wish you had right now. That’s the story behind Hacking Postgres, Ep 9, where Ry sits down with Bertrand Drouvot of AWS Cloud. Today they talked about the struggles of trying to build from scratch vs having a template, what should be core vs an extension, and being able to see what’s really happening inside your database. 


]]> Postgres, Extensions, Software Development No S1E8: Philippe Noël, ParadeDB 8 8 S1E8: Philippe Noël, ParadeDB full f2a78f87-d9ab-43f4-93b2-ac02ca30df04 https://share.transistor.fm/s/cd4a0a83 Search is simple in theory. In practice? Anything but. Join Ry for Episode 8 of Hacking Postgres, where he sits down with Philippe Noël of ParadeDB to talk about how search is evolving, the influence of AI, and the lessons you'd tell your younger self.

]]> Search is simple in theory. In practice? Anything but. Join Ry for Episode 8 of Hacking Postgres, where he sits down with Philippe Noël of ParadeDB to talk about how search is evolving, the influence of AI, and the lessons you'd tell your younger self.

]]> Fri, 10 Nov 2023 10:00:00 -0500 Ry Walker Ry Walker 2166 Search is simple in theory. In practice? Anything but. Join Ry for Episode 8 of Hacking Postgres, where he sits down with Philippe Noël of ParadeDB to talk about how search is evolving, the influence of AI, and the lessons you'd tell your younger self.

]]> Postgres, Extensions, Software Development No S1E7: Burak Yucesoy, Ubicloud 7 7 S1E7: Burak Yucesoy, Ubicloud full 991e7ecf-f4f6-4f2e-89ee-c5639262e103 https://share.transistor.fm/s/03ca7144 Postgres for everything? How about building a new cloud provider? Join us for Ep 7 of Hacking Postgres where Ry talks with Burak Yucesoy of Ubicloud about new clouds, getting attached to extensions, and the future potential of Postgres.

]]> Postgres for everything? How about building a new cloud provider? Join us for Ep 7 of Hacking Postgres where Ry talks with Burak Yucesoy of Ubicloud about new clouds, getting attached to extensions, and the future potential of Postgres.

]]> Fri, 03 Nov 2023 11:00:00 -0400 Ry Walker Ry Walker 2164 Postgres for everything? How about building a new cloud provider? Join us for Ep 7 of Hacking Postgres where Ry talks with Burak Yucesoy of Ubicloud about new clouds, getting attached to extensions, and the future potential of Postgres.

]]> Postgres, Extensions, Software Development No S1E6: Regina Obe and Paul Ramsey, PostGIS 6 6 S1E6: Regina Obe and Paul Ramsey, PostGIS full 00fa5ccc-bac1-4c9e-9400-ac762cd05751 https://share.transistor.fm/s/b243fcf8 Ever wonder what it's like to build a geospatial extension for PostgreSQL? Join us for Episode 6 of Hacking Postgres, where Ry sits down with Regina Obe and Paul Ramsey, two of the key creators of PostGIS.

]]> Ever wonder what it's like to build a geospatial extension for PostgreSQL? Join us for Episode 6 of Hacking Postgres, where Ry sits down with Regina Obe and Paul Ramsey, two of the key creators of PostGIS.

]]> Fri, 27 Oct 2023 10:00:00 -0400 Ry Walker Ry Walker 2112 Ever wonder what it's like to build a geospatial extension for PostgreSQL? Join us for Episode 6 of Hacking Postgres, where Ry sits down with Regina Obe and Paul Ramsey, two of the key creators of PostGIS.

]]> Postgres, Extensions, Software Development No S1E5: Alexander Korotkov, OrioleDB 5 5 S1E5: Alexander Korotkov, OrioleDB full f6e85211-5830-41d2-be4b-e8b34e46d5af https://share.transistor.fm/s/caaa926d In this episode, Ry and Alexander talk about OrioleDB (and the challenge of fighting bloat), fuzzy and vector search, and the challenges behind database management.

]]> In this episode, Ry and Alexander talk about OrioleDB (and the challenge of fighting bloat), fuzzy and vector search, and the challenges behind database management.

]]> Fri, 20 Oct 2023 11:00:00 -0400 Ry Walker Ry Walker 2359 In this episode, Ry and Alexander talk about OrioleDB (and the challenge of fighting bloat), fuzzy and vector search, and the challenges behind database management.

]]> Postgres, Extensions, Software Development No S1E4: Pavlo Golub, Cybertec, pg_timetable 4 4 S1E4: Pavlo Golub, Cybertec, pg_timetable full c46aa38b-ba91-49f6-8a2f-e0e1dd4a964b https://share.transistor.fm/s/1c14f69b 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. 

]]> 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. 

]]> Fri, 13 Oct 2023 10:00:00 -0400 Ry Walker Ry Walker 1459 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. 

]]> Postgres, Extensions, Software Development No S1E3: Eric Ridge, ZomboDB, pgrx, plrust 3 3 S1E3: Eric Ridge, ZomboDB, pgrx, plrust full 024a6338-7c12-499d-89ad-45e1eff48239 https://share.transistor.fm/s/7281db89 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. 

]]> 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. 

]]> Fri, 06 Oct 2023 09:00:00 -0400 Ry Walker Ry Walker 1242 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. 

]]> Postgres, Extensions, Software Development No S1E2: Adam Hendel, Tembo, pg_later, pgmq 2 2 S1E2: Adam Hendel, Tembo, pg_later, pgmq full df79ca64-a878-401f-ae0e-7951bfb27f37 https://share.transistor.fm/s/d2ba7aef Adam Hendel started his career in Military Intelligence before transitioning into the private sector as a Machine Learning Engineer for companies like UnitedHealth, C.H. Robinson, and Shipt. Now, as a Founding Engineer at Tembo, Adam spends his time creating extensions and figuring out how to make “Postgres for Everything” a reality. 

]]> Adam Hendel started his career in Military Intelligence before transitioning into the private sector as a Machine Learning Engineer for companies like UnitedHealth, C.H. Robinson, and Shipt. Now, as a Founding Engineer at Tembo, Adam spends his time creating extensions and figuring out how to make “Postgres for Everything” a reality. 

]]> Wed, 04 Oct 2023 11:49:40 -0400 Ry Walker Ry Walker 1497 Adam Hendel started his career in Military Intelligence before transitioning into the private sector as a Machine Learning Engineer for companies like UnitedHealth, C.H. Robinson, and Shipt. Now, as a Founding Engineer at Tembo, Adam spends his time creating extensions and figuring out how to make “Postgres for Everything” a reality. 

]]> Postgres, Extensions, Software Development No S1E1: Marco Slot, Citus Data, Microsoft 1 1 S1E1: Marco Slot, Citus Data, Microsoft full 4490afdb-ac01-4557-b47b-412dc0057382 https://share.transistor.fm/s/4c02caf3 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.

]]> 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.

]]> Mon, 02 Oct 2023 09:00:00 -0400 Ry Walker Ry Walker 1825 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.

]]> Postgres, Extensions, Software Development No