Understanding Aggregate Functions Performance | The Backend Engineering Show

The Backend Engineering Show with Hussein Nasser

Episode | Podcast

Date: Wed, 23 Mar 2022 18:48:39 GMT

<p>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.</p> <p>0:00 Intro</p> <p>1:22 SELECT COUNT(*)</p> <p>4:30 SELECT AVG(A)</p> <p>5:15 SELECT MAX(A)</p> <p>8:00 Best case scenario</p> <p>11:30 Clustering</p> <p>14:00 Clustering Sequential Writes</p> <p>17:19 Clustering Random Writes</p> <p>20:30 Summary</p>