The future is Postgres (Interview)
Craig Kerstiens returns to talk about the ever-expanding world of Postgres: a deliberately boring core, a thriving extension ecosystem, and pg_lake bringing DuckDB and Iceberg into the mix. We dig into the pain of ETL, what Craig is watching in Postgres 19, the impact of AI on open source maintainers, and why the database still has plenty of room to grow.
Join the discussion
Changelog++ members save 9 minutes on this episode because they made the ads disappear. Join today!
Sponsors:
Coder.com – Secure environments where devs and agents work in parallel. Open by design. Secure by default.
KubeCon + CloudNativeCon – Get a generous discount by using changelogpod (think Earlybird pricing!). Learn more and register.
Fingerprint – Detect threats, AI agents, and bots with device intelligence.
WorkOS – WorkOS is building the infrastructure for the AI era. Explore three new product previews: Airlock for secure AI agent permissions, Atlas for deploying AI-built internal apps, and Passport for seamless, passwordless access to work apps. See the announcements, demos, and highlights in the WorkOS init() 2026 recap.
Featuring:
Craig Kerstiens – Website, GitHub, X
Adam Stacoviak – Website, GitHub, LinkedIn, Mastodon, X
Show Notes:
Iceberg
Parquet
Heroku
Supabase
PlanetScale
PostgreSQL
pg_lake
DuckDB
pgsql-hackers mailing list
Something missing or broken? PRs welcome!
Leveraging the Features of Your Database With Postgres and Python
<p>Are you getting the most out of your Postgres database? What features could you leverage to improve your Python project? This week on the show, Craig Kerstiens from Crunchy Data is here to discuss getting the most out of Postgres.</p>
<p>Craig shares his years of PostgreSQL expertise with advice on getting more from the platform. We talk about rich data types for describing ranges, geospatial data, and JSON. </p>
<p>Craig shares tools for accessing performance statistics from the command line and strategies for optimizing your terminal settings for SQL searches. He discusses Postgres extensions for customizing the database to your needs. Craig also provides multiple resources for learning more and an online tool for practicing within a playground environment.</p>
<div class="alert alert-primary" role="alert">
<p><strong>Course Spotlight:</strong> <a href="https://realpython.com/courses/python-folium-web-maps-from-data/">Creating Web Maps From Your Data With Python Folium</a></p>
<p>You’ll learn how to create web maps from data using Folium. The package combines Python’s data-wrangling strengths with the data-visualization power of the JavaScript library Leaflet. In this video course, you’ll create and style a choropleth world map showing the ecological footprint per country.</p>
</div>
<p>Topics:</p>
<ul>
<li>00:00:00 – Introduction</li>
<li>00:02:36 – What are reasons for considering Postgres?</li>
<li>00:07:41 – Timeline of recent features</li>
<li>00:11:06 – Unique data types</li>
<li>00:16:34 – Storing JSON information</li>
<li>00:20:19 – Video Course Spotlight</li>
<li>00:21:50 – Storing geographic information</li>
<li>00:25:16 – What’s the process for adding extensions?</li>
<li>00:31:33 – Advice for Python developers using Postgres</li>
<li>00:33:31 – Advice on writing SQL</li>
<li>00:38:06 – Command-line tools and customizations</li>
<li>00:48:18 – Django as an entry to Python</li>
<li>00:51:13 – Resources for learning and practicing with Postgres</li>
<li>00:53:45 – What are you excited about in the world of Python?</li>
<li>00:55:55 – What do you want to learn next?</li>
<li>00:58:34 – How can people follow your work online?</li>
<li>00:59:20 – Thanks and goodbye</li>
</ul>
<p>Show Links:</p>
<ul>
<li><a href="https://www.craigkerstiens.com/">Craig Kerstiens - Blog</a></li>
<li><a href="https://www.crunchydata.com/">Trusted Open Source PostgreSQL & Commercial Support for the Enterprise - Crunchy Data</a></li>
<li><a href="https://www.crunchydata.com/why-postgres">Why Postgres? - Crunchy Data</a></li>
<li><a href="https://www.youtube.com/watch?v=C5hd8HyC0YI">Why Postgres - Craig Kerstiens - YouTube</a></li>
<li><a href="https://www.youtube.com/watch?v=HaCaCnZlDcI">A hands on experience with complex SQL - Craig Kerstiens - YouTube</a></li>
<li><a href="https://en.wikipedia.org/wiki/Ingres_(database)">Ingres (database) - Wikipedia</a></li>
<li><a href="https://docs.djangoproject.com/en/4.2/ref/contrib/postgres/fields/">PostgreSQL specific model fields - Django documentation</a></li>
<li><a href="https://wiki.postgresql.org/wiki/Psqlrc">Psqlrc - PostgreSQL wiki</a></li>
<li><a href="https://www.citusdata.com/blog/2019/02/08/the-most-useful-postgres-extension-pg-stat-statements/">The most useful Postgres extension - pg_stat_statements</a></li>
<li><a href="https://www.crunchydata.com/blog/high-compression-metrics-storage-with-postgres-hyperloglog">High-compression Metrics Storage with Postgres Hyperloglog</a></li>
<li><a href="https://www.crunchydata.com/developers/tutorials">Postgres Playground and Tutorials - Crunchy Data</a></li>
<li><a href="https://www.crunchydata.com/blog">PostgreSQL Blog - Crunchy Data</a></li>
<li><a href="https://twitter.com/craigkerstiens/status/1679179083245297664">It’s at least once a week I talk with someone that “loves Postgres” but isn’t sure why… Craig Kerstiens on Twitter: </a></li>
<li><a href="https://thewokbook.com/">The Wok Book: Recipes and Techniques by J. Kenji Lopez-Alt</a></li>
</ul>
<p>Level up your Python skills with our expert-led courses:</p>
<ul>
<li><a href="https://realpython.com/courses/python-folium-web-maps-from-data/">Creating Web Maps From Your Data With Python Folium</a></li>
<li><a href="https://realpython.com/courses/deploying-a-flask-application-using-heroku/">Deploying a Flask Application Using Heroku</a></li>
</ul> <p><a rel="payment" href="https://realpython.com/join">Support the podcast & join our community of Pythonistas</a></p>
Just Postgres (Interview)
This week we’re talking about by Postgres with Craig Kerstiens, Chief Product Officer at Crunchy Data, and a well known ambassador for Postgres. Just Postgres. That’s what this week’s show is about.
Join the discussion
Changelog++ members save 2 minutes on this episode because they made the ads disappear. Join today!
Sponsors:
Sentry – Working code means happy customers. That’s exactly why teams choose Sentry. From error tracking to performance monitoring, Sentry helps teams see what actually matters, resolve problems quicker, and learn continuously about their applications - from the frontend to the backend. Use the code CHANGELOG and get the team plan free for three months.
Postman – Build APIs together — More than 20 million developers use Postman for building and using APIs. Postman simplifies each step of the API lifecycle and streamlines collaboration so you can create better APIs—faster.
Fly.io – The home of Changelog.com — Deploy your apps and databases close to your users. In minutes you can run your Ruby, Go, Node, Deno, Python, or Elixir app (and databases!) all over the world. No ops required. Learn more at fly.io/changelog and check out the speedrun in their docs.
Featuring:
Craig Kerstiens – Website, GitHub, X
Adam Stacoviak – Website, GitHub, LinkedIn, Mastodon, X
Jerod Santo – Website, GitHub, LinkedIn, Mastodon, X
Show Notes:
webstack
The Art of PostgreSQL
Crunchy Data
Postgres Playground
The Changelog #510: Taking Postgres serverless with Nikita Shamgunov from Neon
Something missing or broken? PRs welcome!
What's so exciting about Postgres? (Interview)
PostgreSQL aficionado Craig Kerstiens joins Jerod to talk about his (and our) favorite relational database. Craig details why Postgres is unique in the world of open source databases, which features are most exciting, the many things you can make Postgres do, and what the future might hold. Oh, and some awesome psql tips & tricks!
Join the discussion
Changelog++ members get a bonus 2 minutes at the end of this episode and zero ads. Join today!
Sponsors:
Linode – Get $100 in free credit to get started on Linode – our cloud of choice and the home of Changelog.com. Head to linode.com/changelog
Teamistry – Teamistry is a podcast that tells the stories of teams who work together in new and unexpected ways to achieve remarkable things. Season 2 of Teamistry is out now. Search for Teamistry anywhere you listen to podcasts, or head here to subsribe.
Fastly – Our bandwidth partner. Fastly powers fast, secure, and scalable digital experiences. Move beyond your content delivery network to their powerful edge cloud platform. Learn more at fastly.com.
Equinix – Equinix Metal is built from the ground up to empower developers with low-latency, high performance infrastructure anywhere. Get $500 in free credit to play with plus a rad t-shirt at info.equinixmetal.com/changelog
LaunchDarkly – Test in production! Deploy code at any time, even if a feature isn’t ready to be released to your users. Wrap code in feature flags to get the safety to test new features and infrastructure in prod without impacting the wrong end users.
Featuring:
Craig Kerstiens – Website, GitHub, X
Jerod Santo – Website, GitHub, LinkedIn, Mastodon, X
Show Notes:
Looking Back at Postgres
Customizing My Postgres Shell
ZomboDB
Postgres Weekly
Planet PostgreSQL
pgsql-hackers mailing list
pgsql-novice mailing list
PostgreSQL IRC info
Building a recommendation engine inside Postgres with Python and Pandas
Craig’s twitter thread of building it
Something missing or broken? PRs welcome!
Citus Data: Distributed PostGreSQL for Big Data with Ozgun Erdogan and Craig Kerstiens - Episode 13
Summary
PostGreSQL has become one of the most popular and widely used databases, and for good reason. The level of extensibility that it supports has allowed it to be used in virtually every environment. At Citus Data they have built an extension to support running it in a distributed fashion across large volumes of data with parallelized queries for improved performance. In this episode Ozgun Erdogan, the CTO of Citus, and Craig Kerstiens, Citus Product Manager, discuss how the company got started, the work that they are doing to scale out PostGreSQL, and how you can start using it in your environment.
Preamble
Hello and welcome to the Data Engineering Podcast, the show about modern data infrastructure
When you’re ready to launch your next project you’ll need somewhere to deploy it. Check out Linode at dataengineeringpodcast.com/linode and get a $20 credit to try out their fast and reliable Linux virtual servers for running your data pipelines or trying out the tools you hear about on the show.
Continuous delivery lets you get new features in front of your users as fast as possible without introducing bugs or breaking production and GoCD is the open source platform made by the people at Thoughtworks who wrote the book about it. Go to dataengineeringpodcast.com/gocd to download and launch it today. Enterprise add-ons and professional support are available for added peace of mind.
Go to dataengineeringpodcast.com to subscribe to the show, sign up for the newsletter, read the show notes, and get in touch.
You can help support the show by checking out the Patreon page which is linked from the site.
To help other people find the show you can leave a review on iTunes, or Google Play Music, and tell your friends and co-workers
Your host is Tobias Macey and today I’m interviewing Ozgun Erdogan and Craig Kerstiens about Citus, worry free PostGreSQL
Interview
Introduction
How did you get involved in the area of data management?
Can you describe what Citus is and how the project got started?
Why did you start with Postgres vs. building something from the ground up?
What was the reasoning behind converting Citus from a fork of PostGres to being an extension and releasing an open source version?
How well does Citus work with other Postgres extensions, such as PostGIS, PipelineDB, or Timescale?
How does Citus compare to options such as PostGres-XL or the Postgres compatible Aurora service from Amazon?
How does Citus operate under the covers to enable clustering and replication across multiple hosts?
What are the failure modes of Citus and how does it handle loss of nodes in the cluster?
For someone who is interested in migrating to Citus, what is involved in getting it deployed and moving the data out of an existing system?
How do the different options for leveraging Citus compare to each other and how do you determine which features to release or withhold in the open source version?
Are there any use cases that Citus enables which would be impractical to attempt in native Postgres?
What have been some of the most challenging aspects of building the Citus extension?
What are the situations where you would advise against using Citus?
What are some of the most interesting or impressive uses of Citus that you have seen?
What are some of the features that you have planned for future releases of Citus?
Contact Info
Citus Data
citusdata.com
@citusdata on Twitter
citusdata on GitHub
Craig
Email
Website
@craigkerstiens on Twitter
Ozgun
Email
ozgune on GitHub
Parting Question
From your perspective, what is the biggest gap in the tooling or technology for data management today?
Links
Citus Data
PostGreSQL
NoSQL
Timescale SQL blog post
PostGIS
PostGreSQL Graph Database
JSONB Data Type
PipelineDB
Timescale
PostGres-XL
Aurora PostGres
Amazon RDS
Streaming Replication
CitusMX
CTE (Common Table Expression)
HipMunk Citus Sharding Blog Post
Wal-e
Wal-g
Heap Analytics
HyperLogLog
C-Store
The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA
Support Data Engineering Podcast