[sfg75]

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).