YoVDO

Loading at Hyperscale: Advanced Data Import Techniques for Citus - Citus Con 2022

Offered By: Microsoft via YouTube

Tags

PostgreSQL Courses Distributed Databases Courses Citus Courses

Course Description

Overview

Explore advanced data import techniques for Citus in this 32-minute conference talk from Citus Con 2022. Dive into the fundamentals of loading data, comparing \COPY in Postgres to single-row inserts, before delving into more complex topics. Learn about microbatching \COPY operations, examine a case study on data ordering, and gain insights into direct worker writes in Postgres. Discover the intricacies of distributed triggers and their impact on data loading. Benefit from the expertise of Colton Shepard, a former Citus and Microsoft Solutions Engineer, as he shares valuable knowledge on optimizing data import processes for hyperscale environments.

Syllabus

Introduction.
Single row inserts, upserts, & \COPY .
Microbatched & parallelized \COPY .
Index juggling .
Data ordering with case study .
Distributed triggers .
Direct worker loading .


Taught by

Microsoft Developer

Tags

Related Courses

Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique
Introduction to NoSQL Data Solutions
Microsoft via edX
Developing Planet-Scale Applications in Azure Cosmos DB
Microsoft via edX
Create Couchbase Nodes and Buckets
Pluralsight
Intro to Database Systems - Fall 2018
Carnegie Mellon University via YouTube