I have mentioned this on some previous posted articles but we are really happy users of both citus and pipelinedb. Check out pipelinedb if you are a Postgres f

I have mentioned this on some previous posted articles but we are really happy users of both citus and pipelinedb. Check out pipelinedb if you are a Postgres fan (obviously it is for a different use case than Citus). The only thing I don't like about pipeline is that it currently is a fork and not an extension but that is supposed to change. Consequently we syndicate to citus and pipeline through rabbitmq and Kafka. We use google cloud as well. I'm contemplating on writing a post on what we have learned (and not :)) but I don't think I could ever match the quality of this article. And yes invariably some one will mention memsql does both but it is proprietary and not Postgres. I probably should have spent more time investigating it though (and eventually will).