Building real-time analytics dashboards with Postgres and Citus (citusdata.com) 35 points by spathak 8y ago ↗ HN
[–] sfg75 8y ago ↗ Great article. We use Citus and have a very similar approach :)The article mentions HLL, but there are even more useful extensions (e.g topn to handle tops through the jsonb format).
[–] xstartup 8y ago ↗ I wonder what will happen when you've 30 dimensions and you want to group by one of the 30 dimensions, then group by one of 30 dimensions then group by one of 30 dimensions. Is it possible to to do this stuff with counters?
2 comments
[ 3.6 ms ] story [ 13.7 ms ] threadThe article mentions HLL, but there are even more useful extensions (e.g topn to handle tops through the jsonb format).