Anybody here had experience using Citus Community version? Is it hard to maintain? I was trying to use it on my multi-tenant project but don't really know the maintenance implications.
If you're looking to use Citus Community edition for your multi-tenant project, one thing to keep in mind is how you set up replication.
Citus comes with two replication methods: streaming and statement replication. The streaming replication method is more suitable for multi-tenant apps. In the Citus Community version (if you need replication), you will need to set this up yourself.
https://www.postgresql.org/docs/current/static/warm-standby....
As far as maintaining it, there are of course a number of benefits to the managed service side and then the enterprise version if you want to run on your own hardware and self-manage. If you're comfortable running and managing your own Postgres then the community version could absolutely work for you, here's actually a recent write-up from Hipmunk who is using the community version - https://hipmunk.github.io/posts/2017/Aug/16/a-fare-cache-in-...