If you haven't already seen it, Dan from Heap Analytics has a great talk about how they use Postgres and Citus.<p><a href="https://www.youtube.com/watch?v=NVl9_6J1G60" rel="nofollow">https://www.youtube.com/watch?v=NVl9_6J1G60</a>
We[0] just recently moved from Hbase to Postgres w/ Citus. Still not fully settled in, but got incredible support from the Citus team (seriously amazing guys) and things are looking much brighter than before.<p>On a 8 worker nodes (16 cores, 80GB ram, 3TB SSD), we're at around 20k inserts/second, while most of the selects are running at around 100ms (besides some counts and complex queries).<p>If you have a lot of data and know Postgres, give it a chance.<p>[0] <a href="https://pexe.so" rel="nofollow">https://pexe.so</a>
If you're looking for a metrics backend built on traditional Postgres, check out Tgres.<p><a href="http://grisha.org/blog/2016/07/29/state-of-tgres-2016/" rel="nofollow">http://grisha.org/blog/2016/07/29/state-of-tgres-2016/</a>
For anyone with questions about how to properly shard a table, how to fit a problem to a distribution strategy, or general questions about deployment, Citus has a Slack channel which is active and extremely welcoming. You can request an invite here: <a href="https://slack.citusdata.com/" rel="nofollow">https://slack.citusdata.com/</a><p>Disclaimer: don't work there, but on the Slack and the Citus team is nothing short of awesome.
I had a look at Citus when evaluating time series databases and the documents said that work was still under way on masterless setup for faster ingestion (up to 500k metrics /sec).<p><a href="https://docs.citusdata.com/en/v5.2/performance/scaling_data_ingestion.html#masterless-citus-50k-s-500k-s" rel="nofollow">https://docs.citusdata.com/en/v5.2/performance/scaling_data_...</a><p>If that has changed I'd add it to my table.<p><a href="https://docs.google.com/spreadsheets/d/1sMQe9oOKhMhIVw9WmuCEWdPtAoccJ4a-IuZv4fXDHxM/edit#gid=0" rel="nofollow">https://docs.google.com/spreadsheets/d/1sMQe9oOKhMhIVw9WmuCE...</a>