Ozgun Erdogan's guest appearances

Ozgun Erdogan

Data Engineering Podcast

Software Daily

Nikita Shamgunov

Christopher Ryan

Emily Miller

Peter Bull

Patrick Hunt

Jonathan Katz

Kevin Moore

Dan Robinson

Matthew Rocklin

Maxime Beauchemin

Jean Georges Perrin

Todd Walter

Mark Marinelli

Andy LoPresto

Joe Crobak

OwlTail

Craig Kerstiens

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-SASupport Data Engineering Podcast

<h2>Summary</h2> <p>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.</p> <h2>Preamble</h2> <ul> <li>Hello and welcome to the Data Engineering Podcast, the show about modern data infrastructure</li> <li>When you’re ready to launch your next project you’ll need somewhere to deploy it. Check out Linode at <a href="https://www.dataengineeringpodcast.com/linode?utm_source=rss&amp;utm_medium=rss" rel="nofollow" target="_blank">dataengineeringpodcast.com/linode</a> 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.</li> <li>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 <a href="https://www.dataengineeringpodcast.com/gocd?utm_source=rss&amp;utm_medium=rss" rel="nofollow" target="_blank">dataengineeringpodcast.com/gocd</a> to download and launch it today. Enterprise add-ons and professional support are available for added peace of mind.</li> <li>Go to <a href="https://www.dataengineeringpodcast.com?utm_source=rss&amp;utm_medium=rss" rel="nofollow" target="_blank">dataengineeringpodcast.com</a> to subscribe to the show, sign up for the newsletter, read the show notes, and get in touch.</li> <li>You can help support the show by checking out the <a href="https://www.patreon.com/dataengineeringpodcast?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Patreon page</a> which is linked from the site.</li> <li>To help other people find the show you can leave a review on <a href="https://itunes.apple.com/us/podcast/data-engineering-podcast/id1193040557?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">iTunes</a>, or <a href="https://goo.gl/app/playmusic?ibi=com.google.PlayMusic&amp;isi=691797987&amp;ius=googleplaymusic&amp;link=https://play.google.com/music/m/Ivucmwlkrxbgfe5dhj562xgev4u?t%3DData_Engineering_Podcast%26pcampaignid%3DMKT-na-all-co-pr-mu-pod-16&amp;utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Google Play Music</a>, and tell your friends and co-workers</li> <li>Your host is Tobias Macey and today I’m interviewing Ozgun Erdogan and Craig Kerstiens about Citus, worry free PostGreSQL</li> </ul> <h2>Interview</h2> <ul> <li>Introduction</li> <li>How did you get involved in the area of data management?</li> <li>Can you describe what Citus is and how the project got started?</li> <li>Why did you start with Postgres vs. building something from the ground up?</li> <li>What was the reasoning behind converting Citus from a fork of PostGres to being an extension and releasing an open source version?</li> <li>How well does Citus work with other Postgres extensions, such as PostGIS, PipelineDB, or Timescale?</li> <li>How does Citus compare to options such as PostGres-XL or the Postgres compatible Aurora service from Amazon?</li> <li>How does Citus operate under the covers to enable clustering and replication across multiple hosts?</li> <li>What are the failure modes of Citus and how does it handle loss of nodes in the cluster?</li> <li>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?</li> <li>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?</li> <li>Are there any use cases that Citus enables which would be impractical to attempt in native Postgres?</li> <li>What have been some of the most challenging aspects of building the Citus extension?</li> <li>What are the situations where you would advise against using Citus?</li> <li>What are some of the most interesting or impressive uses of Citus that you have seen?</li> <li>What are some of the features that you have planned for future releases of Citus?</li> </ul> <h2>Contact Info</h2> <ul> <li>Citus Data <ul> <li><a href="https://www.citusdata.com?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">citusdata.com</a></li> <li><a href="https://twitter.com/citusdata?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">@citusdata</a> on Twitter</li> <li><a href="https://github.com/citusdata?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">citusdata</a> on GitHub</li> </ul> <p></p></li> <li>Craig<p></p> <ul> <li><a href="mailto:craig@citusdata.com">Email</a></li> <li><a href="http://www.craigkerstiens.com/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Website</a></li> <li><a href="https://twitter.com/craigkerstiens?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">@craigkerstiens</a> on Twitter</li> </ul> <p></p></li> <li>Ozgun<p></p> <ul> <li><a href="mailto:ozgun@citusdata.com">Email</a></li> <li><a href="https://github.com/ozgune?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">ozgune</a> on GitHub</li> </ul> <p></p></li> </ul><p></p> <h2>Parting Question</h2> <ul> <li>From your perspective, what is the biggest gap in the tooling or technology for data management today?</li> </ul> <h2>Links</h2> <ul> <li><a href="https://www.citusdata.com/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Citus Data</a></li> <li><a href="https://www.postgresql.org/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">PostGreSQL</a></li> <li><a href="https://en.wikipedia.org/wiki/NoSQL?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">NoSQL</a></li> <li><a href="https://blog.timescale.com/why-sql-beating-nosql-what-this-means-for-future-of-data-time-series-database-348b777b847a?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Timescale SQL blog post</a></li> <li><a href="https://postgis.net/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">PostGIS</a></li> <li><a href="https://github.com/bitnine-oss/agensgraph?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">PostGreSQL Graph Database</a></li> <li><a href="https://www.postgresql.org/docs/10/static/datatype-json.html?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">JSONB Data Type</a></li> <li><a href="https://www.pipelinedb.com/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">PipelineDB</a></li> <li><a href="http://www.timescale.com/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Timescale</a></li> <li><a href="https://www.postgres-xl.org/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">PostGres-XL</a></li> <li><a href="https://aws.amazon.com/rds/aurora/details/postgresql-details/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Aurora PostGres</a></li> <li><a href="https://aws.amazon.com/rds/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Amazon RDS</a></li> <li><a href="https://wiki.postgresql.org/wiki/Streaming_Replication?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Streaming Replication</a></li> <li><a href="https://www.citusdata.com/blog/2016/09/22/announcing-citus-mx/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">CitusMX</a></li> <li><a href="https://www.postgresql.org/docs/current/static/queries-with.html?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">CTE (Common Table Expression)</a></li> <li><a href="https://hipmunk.github.io/posts/2017/Aug/16/a-fare-cache-in-a-sharded-data-cluster/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">HipMunk Citus Sharding Blog Post</a></li> <li><a href="https://github.com/wal-e/wal-e?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Wal-e</a></li> <li><a href="https://www.citusdata.com/blog/2017/08/18/introducing-wal-g-faster-restores-for-postgres/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Wal-g</a></li> <li><a href="https://heapanalytics.com/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">Heap Analytics</a></li> <li><a href="https://www.citusdata.com/blog/2017/04/04/distributed_count_distinct_with_postgresql/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">HyperLogLog</a></li> <li><a href="https://github.com/citusdata/cstore_fdw?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">C-Store</a></li> </ul> <p>The intro and outro music is from <a href="http://freemusicarchive.org/music/The_Freak_Fandango_Orchestra/Love_death_and_a_drunken_monkey/04_-_The_Hug?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">The Hug</a> by <a href="http://freemusicarchive.org/music/The_Freak_Fandango_Orchestra/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">The Freak Fandango Orchestra</a>  / <a href="http://creativecommons.org/licenses/by-sa/3.0/?utm_source=rss&amp;utm_medium=rss" rel="noopener nofollow" target="_blank">CC BY-SA</a></p><p><a href="https://dataengineering.supercast.com/" rel="payment nofollow" target="_blank">Support Data Engineering Podcast</a></p>

Citus Data: Distributed PostGreSQL for Big Data with Ozgun Erdogan and Craig Kerstiens - Episode 13