---
title: "#probabilisticdatastructures articles | Hashnode"
description: "Explore 1 articles tagged #probabilisticdatastructures on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/probabilisticdatastructures"
---

Tag

# #probabilisticdatastructures

1 posts · 0 followers

[Doogal Simpson](https://hashnode.com/@doogal) · [Mar 18](https://hashnode.com/posts/why-your-database-hates-count-distinct-and-why-hyperloglog-is-the-cure/69bac7d98c55d6eefb313c7c)

### [Why Your Database Hates COUNT(DISTINCT) and Why HyperLogLog is the Cure](https://doogal.dev/why-your-database-hates-count-distinct-and-why-hyperloglog-is-the-cure?utm_source=hashnode&utm_medium=feed)

Avoid the memory explosion of COUNT(DISTINCT) at scale. Use the coin-flipping math of HyperLogLog to estimate millions of unique views with constant space.

4 min read · [doogal.dev](https://doogal.dev/why-your-database-hates-count-distinct-and-why-hyperloglog-is-the-cure?utm_source=hashnode&utm_medium=feed)
