3 ms·
I just started learning Citus, it is a very promising product. Couple of things for improvement / may be already supported. 1. New User records do not propaga
by crudbug 10y ago
I just started learning Citus, it is a very promising product.
Couple of things for improvement / may be already supported.
1. New User records do not propagate to all the nodes - Manual Step.
2. New Database records do not propagate to all the nodes - Manual Step.
3. Materialized View with incremental refresh - Currently Postgres re-runs the query everytime there is a data change - For a table of billion records this is very inefficient.
- anarazel 10y ago> 1. New User records do not propagate to all the nodes - Manual Step. > 2. New Database records do not propagate to all the nodes - Manual Step. The issue here is that both databases, users and some other objects aren't "database local" but "cluster wide" objects (i.e. visible in all the databases of a postgresql installation). As the citus extension isn't necessarily created in all of them we can't reliably do anything about this...