Podorbit
DiscoverPodcastsGuestsCompanies
Podorbit

Tech podcasts · indexed by guest & company

PrivacyTermsSupport
support@podorbit.app

Craig Kerstiens

Chief Product Officer

Crunchy DataCrunchy DataCitus DataCitus Data

Appearances (5)

The Changelog: Software Development, Open Source/Oct 28, 2026/1h 46m

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!

Craig Kerstiens

Chief Product Officer

Crunchy DataCrunchy DataCitus DataCitus Data
The Real Python Podcast/Jul 21, 2023/1h 1m

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&rsquo;ll learn how to create web maps from data using Folium. The package combines Python&rsquo;s data-wrangling strengths with the data-visualization power of the JavaScript library Leaflet. In this video course, you&rsquo;ll create and style a choropleth world map showing the ecological footprint per country.</p> </div> <p>Topics:</p> <ul> <li>00:00:00 &ndash; Introduction</li> <li>00:02:36 &ndash; What are reasons for considering Postgres?</li> <li>00:07:41 &ndash; Timeline of recent features</li> <li>00:11:06 &ndash; Unique data types</li> <li>00:16:34 &ndash; Storing JSON information</li> <li>00:20:19 &ndash; Video Course Spotlight</li> <li>00:21:50 &ndash; Storing geographic information</li> <li>00:25:16 &ndash; What&rsquo;s the process for adding extensions?</li> <li>00:31:33 &ndash; Advice for Python developers using Postgres</li> <li>00:33:31 &ndash; Advice on writing SQL</li> <li>00:38:06 &ndash; Command-line tools and customizations</li> <li>00:48:18 &ndash; Django as an entry to Python</li> <li>00:51:13 &ndash; Resources for learning and practicing with Postgres</li> <li>00:53:45 &ndash; What are you excited about in the world of Python?</li> <li>00:55:55 &ndash; What do you want to learn next?</li> <li>00:58:34 &ndash; How can people follow your work online?</li> <li>00:59:20 &ndash; 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 &amp; 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&rsquo;s at least once a week I talk with someone that &ldquo;loves Postgres&rdquo; but isn&rsquo;t sure why&hellip; 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 &amp; join our community of Pythonistas</a></p>

Craig Kerstiens

Chief Product Officer

Crunchy DataCrunchy DataCitus DataCitus Data
The Changelog: Software Development, Open Source/Jan 20, 2023/1h 12m

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 &ndash; Website, GitHub, X Adam Stacoviak &ndash; Website, GitHub, LinkedIn, Mastodon, X Jerod Santo &ndash; 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!

Craig Kerstiens

Chief Product Officer

Crunchy DataCrunchy DataCitus DataCitus Data
The Changelog: Software Development, Open Source/Oct 23, 2020/1h 8m

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 &ndash; Website, GitHub, X Jerod Santo &ndash; 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!

Craig Kerstiens

Chief Product Officer

Crunchy DataCrunchy DataCitus DataCitus Data
Data Engineering Podcast/Jan 8, 2018/47m

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

Ozgun Erdogan

CTO

Citus DataCitus Data
Craig Kerstiens

Chief Product Officer

Citus DataCitus DataCrunchy DataCrunchy Data