29:52Lessons from Optimizing Citus Queries at Heap | Citus Con: An Event for Postgres 2022
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
29:52
04:07
11:04"Anti-Slop" Designs with Impeccable (a Crash Course) #5 - Enable Image Generation
Net Ninja
2:25:40
42:55Java Graphics Programming Tutorial - How To Draw Shapes, Paths, Curves, and Apply Transformations
choobtorials
08:10
18:31