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.

ios

What's new in Bootstrap 5 and when Bootstrap 5 release date?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Random Password Generator Online

HTML Color Picker online | HEX Color Picker | RGB Color Picker

Android Vs iOS - Which is Better for App Development?

Learn the difference between Android and iOS both of which are very famous operating systems. Learn which is better for app development?

Top iOS Mobile App Development Agency in New York

Are you looking for a [Top iOS Mobile App Development Agency in New York]**(https://www.appcluesinfotech.com/ios-app-develop**ment-company/ "Top iOS Mobile App Development Agency in New York") for your app projects? Then AppClues Infotech is the...

Custom iOS App Development Company New York

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

New iOS Jailbreak Tool Works on iPhone Models iOS 11 to iOS 13.5

Latest version of UnC0ver uses unpatched zero-day exploit to take complete control of devices, even those running iOS 13.5.

Top Rated iOS Mobile Application Development Company in New York (NYC)

Get a Free Quote on Android App Development, iPhone App Development, Ionic App Development, Video Development, ASO, SEO, Google Ads/Adwords, SEO for your app Idea.