High performance HTAP with Postgres & Hyperscale (Citus) | Interview with Marco Slot

With Hyperscale (Citus) you can now scale out Postgres horizontally, transforming Postgres into a distributed database that can do almost anything—including meeting the needs of data-intensive HTAP applications. HTAP stands for “hybrid transactional analytical processing.” This interview, with demo, explores the promise of HTAP—that there is finally a database that can do transactions and analytics at scale—and shows how you can use Postgres with Hyperscale (Citus) on Azure to serve both the transactional & analytical needs of HTAP applications.   Join Marco Slot, principal engineer and lead for the Citus open source project at Microsoft, and Citus open source advocate Claire Giordano—for an interview and demo, with a side-by-side performance comparison of Hyperscale (Citus) on Azure Database for PostgreSQL compared to a single Postgres server. The demo uses HammerDB to simulate a transactional workload and also features rollups that combined with the parallelism of Citus deliver low-latency analytical query results.  This interview was originally aired at the Microsoft European Virtual Open Source Summit.  Video bookmarks: ► 2:11 The Postgres team at Microsoft ► 3:24 About Marco Slot, lead of Citus open source ► 6:52 Importance of Postgres extensions ► 8:41 The Citus open source extension to Postgres ► 10:27 Interview Q&A with Marco Slot ► 17:15 HTAP demo with Postgres & Hyperscale (Citus) ► 31:01 How Windows telemetry team uses Postgres & Citus Citus is an open source extension to Postgres that changes the game for HTAP workloads. Because Citus is an extension to Postgres, Citus gives you all the transactional and indexing capabilities of Postgres. And because Citus distributes both your data and your queries across multiple servers, Citus gives you low-latency analytics even in the face of high concurrency and billions of rows of data. 

For more tips like this, check out the working remotely playlist at www.youtube.com/FoetronAcademy . Also, if you need any further assistance then you can raise a support ticket and get it addressed.