DEMO - High performance HTAP with Postgres & Hyperscale (Citus)

DEMO - High performance HTAP with Postgres & Hyperscale (Citus)

In this demo, we run a large-scale HTAP workload on Azure Database for PostgreSQL with the built-in Hyperscale (Citus) deployment option. Hyperscale (Citus) ...

In this demo, we run a large-scale HTAP workload on Azure Database for PostgreSQL with the built-in Hyperscale (Citus) deployment option. Hyperscale (Citus) uses the open source Citus extension to Postgres to turn a cluster of PostgreSQL servers into a single distributed database that can shard or replicate Postgres tables across the cluster. Citus can simultaneously scale transaction throughput by routing transactions to the right server, and scale analytical queries and data transformations by parallelizing them across all of the servers in the database cluster. In combination with all the powerful Postgres features such as its different index types and other PostgreSQL extensions, this makes Hyperscale (Citus) able to run high performance HTAP workloads at scale.

We will show a side-by-side comparison of Hyperscale (Citus) and a single PostgreSQL server running a transactional workload generated by HammerDB, while simultaneously running analytical queries, and show how you get further speedups by pre-aggregating the data in parallel (using rollups) on the same Postgres database.

Video bookmarks: ► 0:17 What Citus is ► 0:37 Overview of anatomy of the demo ► 1:47 Demo begins ► 9:55 Summary of performance results ► 10:58 Marco’s interpretation of the demo ► 14:14 How Windows telemetry team uses Postgres & Citus

This demo, originally shared at SIGMOD and excerpted from an interview Claire Giordano did with Marco Slot at the Microsoft European Virtual Open Source Summit—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 transactional & analytical needs of HTAP applications.


What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Hire iOS App Developer

Are you looking to transform your idea into an iPhone application? Hire iPhone programmer team from **[]( "")** to ensure the best results, utilizing all the latest trends in iOS app...

Android App to iOS App Porting Services in Virginia, USA | SISGAIN

Port your android App to iOS Platform from SISGAIN by the highly dedicated developers.

Hire Best iOS Application Developer in Virginia, USA | SISGAIN

Hire ios developers or swift programmers having industry experience to work on complex projects.

Which company is best for iOS application development?

Hire the best iOS mobile app development company in New York, AppClues Infotech specialized in custom iOS app development and design services.

Best iOS & Android App Development Services in USA

AppClues Infotech is a top Mobile App Development Company in USA building high-quality Android, iOS, and Native apps for Startups, SMBs, & Enterprises. Contact us now!