tubeshowcase●1,669,463 videos♡ My collection 0
← Learn to Code

Learn to Code23:03

Lessons from Optimizing Citus Queries at Heap | Citus Con: An Event for Postgres 2022

Microsoft Developer ↗

From the creator

This talk from Citus Con: An Event for Postgres was delivered by Matt Dupree and will be a mashup of the lessons about Postgres and Citus queries described in a few recent, popular Heap technical blog posts on this subject. We'll cover: • a quirk about index only scans • how audit tables saved us from taking down production during an experimental, performance-motivated database schema migration • how we optimize citus queries at scale with Postgres Matt Dupree is a data science engineer at Heap, working in R and PostgreSQL. Matt has developed in android code, javascript, python, go, and ruby. Matt has spent a lot of time trying to make the Citus queries fast at Heap. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:26 Performance challenge @ Heap ⏩ 03:22 Define confidence intervals & apply to experiments ⏩ 08:18 How to get index-only scans on column expressions ⏩ 14:17 Use audit tables to identify problems ⏩ 22:00 Recap ✅ Learn more: Watch more Citus Con talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect: Twitter – @CitusCon, https://twitter.com/CitusCon #CitusCon #PostgreSQL #Citus

Published 2022-04-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code