Building a Scalable Postgres Metrics Backend Using the Citus Extension

If you haven&#x27;t already seen it, Dan from Heap Analytics has a great talk about how they use Postgres and Citus.<p><a href="https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=NVl9_6J1G60" rel="nofollow">https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=NVl9_6J1G60</a>

We[0] just recently moved from Hbase to Postgres w&#x2F; 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&#x27;re at around 20k inserts&#x2F;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:&#x2F;&#x2F;pexe.so" rel="nofollow">https:&#x2F;&#x2F;pexe.so</a>

If you&#x27;re looking for a metrics backend built on traditional Postgres, check out Tgres.<p><a href="http:&#x2F;&#x2F;grisha.org&#x2F;blog&#x2F;2016&#x2F;07&#x2F;29&#x2F;state-of-tgres-2016&#x2F;" rel="nofollow">http:&#x2F;&#x2F;grisha.org&#x2F;blog&#x2F;2016&#x2F;07&#x2F;29&#x2F;state-of-tgres-2016&#x2F;</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:&#x2F;&#x2F;slack.citusdata.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;slack.citusdata.com&#x2F;</a><p>Disclaimer: don&#x27;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 &#x2F;sec).<p><a href="https:&#x2F;&#x2F;docs.citusdata.com&#x2F;en&#x2F;v5.2&#x2F;performance&#x2F;scaling_data_ingestion.html#masterless-citus-50k-s-500k-s" rel="nofollow">https:&#x2F;&#x2F;docs.citusdata.com&#x2F;en&#x2F;v5.2&#x2F;performance&#x2F;scaling_data_...</a><p>If that has changed I&#x27;d add it to my table.<p><a href="https:&#x2F;&#x2F;docs.google.com&#x2F;spreadsheets&#x2F;d&#x2F;1sMQe9oOKhMhIVw9WmuCEWdPtAoccJ4a-IuZv4fXDHxM&#x2F;edit#gid=0" rel="nofollow">https:&#x2F;&#x2F;docs.google.com&#x2F;spreadsheets&#x2F;d&#x2F;1sMQe9oOKhMhIVw9WmuCE...</a>