YoVDO

Citus 11 - New Features and Enhanced Query Throughput Scalability

Offered By: Microsoft via YouTube

Tags

PostgreSQL Courses Distributed Databases Courses Load Balancing Courses Citus Courses

Course Description

Overview

Explore the upcoming features and enhancements of Citus 11 in this 32-minute conference talk presented by Marco Slot at Citus Con: An Event for Postgres 2022. Discover how the new release enables enhanced query throughput scalability by allowing queries from any node in a Citus database cluster. Watch a live demonstration showcasing the full potential of Citus 11 for scaling PostgreSQL query throughput. Learn about additional new features in the Citus extension, including automatic schema and metadata syncing, distributed sequences, and load-balancing across nodes. Gain insights into monitoring a distributed Postgres cluster and configuring for high concurrency. Examine recent benchmark numbers revealing impressive throughput performance for Citus. The talk concludes with information on the Citus 11 beta and a Q&A session with Marco Slot and Claire Giordano.

Syllabus

Introduction.
Citus development.
Querying via any node (11.0+).
Automatic schema & metadata syncing.
Monitoring a distributed Postgres cluster.
Configuring for high concurrency.
Distributed sequences.
Load-balancing across nodes.
Measuring insert throughput to Azure.
Demo of Citus 11.
Citus 11 beta.
Q&A with Marco & Claire .


Taught by

Microsoft Developer

Tags

Related Courses

Web Application Development: The Data Tier
University of New Mexico via Coursera
Desarrollo de Aplicaciones Web: Nivel de Datos
University of New Mexico via Coursera
Hacking PostgreSQL: Data Access Methods
Ural Federal University via edX
Spatial Data Science and Applications
Yonsei University via Coursera
RDBMS PostgreSQL
Indian Institute of Technology Bombay via Swayam