Sharding Postgres without extensions with PgDog founder, Lev Kokotov
Database School19 Elo 2025

Sharding Postgres without extensions with PgDog founder, Lev Kokotov

I chat with Lev Kokotov to talk about building PgDog, an open-source sharding solution for Postgres that sits outside the database. Lev shares the journey from creating PgCat to launching PgDog through YC, the technical challenges of sharding, and why he believes scaling Postgres shouldn’t require extensions or rewrites.


Follow Lev:

  • Twitter: https://twitter.com/levpgdog
  • PgDog: https://pgdog.dev


Follow Aaron:

  • Twitter: https://twitter.com/aarondfrancis
  • LinkedIn: https://www.linkedin.com/in/aarondfrancis
  • Website: https://aaronfrancis.com — find articles, podcasts, courses, and more.
  • Database School: https://databaseschool.com



Chapters

  • 00:00 - Intro
  • 01:27 - Lev’s self-taught to computer science degree journey
  • 04:50 - Transition to Postgres discussion
  • 05:24 - History of PgCat
  • 07:06 - What PG Cat does and key features
  • 08:59 - Why Lev built PgCat instead of extending PG Bouncer
  • 10:06 - PG Cat’s current status and usage
  • 12:20 - Moving from PgCat to PgDog
  • 13:09 - Applying to YC as a solo founder
  • 16:24 - YC pitch: the market gap for Postgres sharding
  • 18:52 - High-level overview of PgDog
  • 23:32 - Why PgDog is not an extension
  • 25:57 - When to build Postgres extensions vs standalone tools
  • 27:49 - PgDog architecture and query parsing
  • 30:39 - Handling cross-shard queries and current capabilities
  • 33:47 - How PgDog shards an existing large Postgres database
  • 36:37 - Parallel replication streams for faster sharding
  • 39:07 - Alternate resharding approaches
  • 42:52 - Where PgDog draws the orchestration line
  • 44:00 - Vision for PgDog Cloud vs bring-your-own-database
  • 46:47 - Company status: first hire, design partners, and production use
  • 50:45 - How deploys work for customers
  • 52:20 - Importance of building closely with design partners
  • 54:05 - Paid design partnerships and initial deployments
  • 56:23 - Benefit of sitting outside Postgres for compatibility
  • 58:32 - Near-term roadmap and long-term vision
  • 1:01:03 - Where to find Lev online

Jaksot(30)

How Durable Objects and D1 Work: A Deep Dive with Cloudflare’s Josh Howard

How Durable Objects and D1 Work: A Deep Dive with Cloudflare’s Josh Howard

Josh Howard, Senior Engineering Manager at Cloudflare, joins me to explain how Durable Objects and D1 work under the hood—and why Cloudflare’s approach to stateful serverless infrastructure is so uniq...

14 Touko 20251h 14min

20 years of hacking Postgres with Heikki Linnakangas (cofounder of Neon)

20 years of hacking Postgres with Heikki Linnakangas (cofounder of Neon)

In this episode of Database School, I talk with Heikki Linnakangas, co-founder of Neon and longtime PostgreSQL hacker, to talk about 20+ years in the Postgres community, the architecture behind Neon, ...

6 Touko 20252h

Building a serverless database replica with Carl Sverre

Building a serverless database replica with Carl Sverre

Want to learn more SQLite? Check out my SQLite course: https://highperformancesqlite.com In this episode, Carl Sverre and I discuss why syncing everything is a bad idea and how his new project, Graft,...

18 Huhti 20251h 28min

Postgres on bare metal with the CEO of Prisma

Postgres on bare metal with the CEO of Prisma

Prisma started as a GraphQL backend and pivoted into one of the most widely used ORMs in the world. Now, they’ve launched Prisma Postgres, and CEO Søren Bramer Schmidt is here to break down the journe...

17 Helmi 20251h 24min

Moving from Redis to SQLite with Mike Buckbee

Moving from Redis to SQLite with Mike Buckbee

Want to learn more SQLite? Check out my SQLite course: https://highperformancesqlite.com In this episode, I sit down with Mike Buckbee to dive into the nitty-gritty of web application firewalls and hi...

26 Marras 20241h 9min

Bootstrapping an email service provider (with Jesse Hanley)

Bootstrapping an email service provider (with Jesse Hanley)

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. In this interview, I talk with Jesse Hanley, founder of Bento, about running a lean email service from Japan. ...

14 Loka 20241h 21min

Creating a Postgres platform with Monica & Tudor from Xata.io

Creating a Postgres platform with Monica & Tudor from Xata.io

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. Production ready Postgres for teams that ship fast: https://xata.io In this interview, I talk with Monica Sarb...

7 Loka 20241h 1min

Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens

Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. In this interview, I dive deep with Craig Kerstiens from Crunchy Data into the world of Postgres, covering its...

24 Syys 20241h 2min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
voi-hyvin-meditaatiot-2
rss-narsisti
psykopodiaa-podcast
rss-niinku-asia-on
rss-vapaudu-voimaasi
adhd-podi
psykologia
rss-duodecim-lehti
rss-rahamania
rss-valo-minussa-2
kesken
rss-uskonto-on-tylsaa
aamukahvilla
koulu-podcast-2
rss-liian-kuuma-peruna
rss-koira-haudattuna
avara-mieli
rss-turun-yliopisto
rss-arkea-ja-aurinkoa-podcast-espanjasta