Citus Blog

Archive for Dec 22, 2017

Murat Tuncer

Distributed count distinct vs. HyperLogLog in Postgres

Written byBy Murat Tuncer | December 22, 2017Dec 22, 2017

Citus 7.1 shipped just a few weeks back and included a number of great new features. In case you missed the details check out Ozgun’s blog or read up on what Citus is on our site. Today though we want to drill further into an important area in Postgres, counting.

Getting a distinct count of some value out of your database is a common question. We've talked about how to count more quickly on our blog before, and followed that up with how you can use probabilistic algorithms like HyperLogLog to do counts faster.

Keep reading

Page 1 of 1