Skip to content
Understanding Aggregate Functions Performance | The Backend Engineering Show episode artwork

Mar 23, 2022 23 min

Understanding Aggregate Functions Performance | The Backend Engineering Show

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Understanding Aggregate Functions Performance | The Backend Engineering Show

0:00 23:39

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 23 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on March 23, 2022.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.