This is why I love HN. People give their real-world scenarios.

Thank you for recommending pipelinedb, I haven't come across them before.

I have kafka and postgres and in need of real-time analytics, this may be the solution I'm looking for.

I've used citus in the past, whilst it's excellent for data-warehousing. Unless you scale up the servers, then it's not suitable for real-time counts. I found that lacking for my use-case.

If you see this, can you reach out at my name @ gmail dot com, I'd like to chat about issues you have come across.

If you need both citus + pipelinedb then memsql.com will solve your problem with a much more polished solution. MySQL dialect instead of PostgreSQL but that's rarely a problem for a data warehouse.

Thanks. I actually have scheduled a demo. In the meantime will download the community version and have a play.