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

Choosing the Right Shard Key for Efficiently Distributing Postgres with Citus
Microsoft via YouTube
8 Keys to the Growth of Citus and Distributed PostgreSQL - Keynote
Microsoft via YouTube
Citus Cluster Zero-Downtime Migration - Algolia's Experience
Microsoft via YouTube
Developing IO Prefetching for PostgreSQL
Microsoft via YouTube
Citus Con: An Event for Postgres - EMEA Livestream
Microsoft via YouTube