My use case is kind of special - it involves genomic data which doesn’t normally change frequently. Many genomic systems (InterMine, Flybase) use PostgreSQL and many are very happy with it - also SDB (Saccharomyces DB) and MGB (Mouse Genome dB) recently moved from Oracle to PostgreSQL (a trend that I would like to see accelerating - and from there ultimately to CockroachDB ).
Now, I’m interested in CockroachDB for its scaling but am concerned about performance. Our system is updated approx. every 2 months or so which leads me to my question.
Is it possible to set tables and/or the entire db to be read-only to avoid/reduce inter-node communication traffic during “normal service” - we could then turn this off for updates during a maintenance window?