Igeometry Podcast
Understanding Aggregate Functions Performance | The Backend Engineering Show
- Author: Vários
- Narrator: Vários
- Publisher: Podcast
- Duration: 0:23:39
- More information
Informações:
Synopsis
Aggregate functions like Count, max, min, avg performance really depends on how did you tune your database for that kind of workload. Let us discuss this. 0:00 Intro 1:22 SELECT COUNT(*) 4:30 SELECT AVG(A) 5:15 SELECT MAX(A) 8:00 Best case scenario 11:30 Clustering 14:00 Clustering Sequential Writes 17:19 Clustering Random Writes 20:30 Summary --- Support this podcast: https://anchor.fm/hnasr/support
