This is a pretty impressive set of new features and fixes (i.e. things that worked in Postgres, but not with CitusDB).<p>In particular, the added ability to run `CREATE INDEX CONCURRENTLY` [1] for distributed tables is an important addition. I've run a pretty big Postgres database before, and this feature is absolutely _critical_ for bringing new indexes online for large tables without affecting users or other operations (without it, `CREATE INDEX` needs a lock that blocks other modifications in the table).<p>Its reverse, `DROP INDEX CONCURRENTLY` is a relatively newer addition to Postgres and also pretty key. While running on pre-9.2 (when it was added), we had to stop dropping indexes from large tables because the operation would block long enough that we'd start timing out user requests while it was running.<p>[1] <a href="https://www.postgresql.org/docs/current/static/sql-createindex.html" rel="nofollow">https://www.postgresql.org/docs/current/static/sql-createind...</a>
I wonder how they'll compete with Cockroach down the road. Looks like both projects are doing great work around ACID in multi-tenant environments.
Just a quick comment on this:<p>> Good software never stops evolving<p>I think I would translate this as: "our software is so large in scope, it must never stop evolving if it is to remain good enough."<p>Small software, with a single, focused goal, can evolve to a steady state which is still good.<p>Often we need to build things whose scope is too large for that, and must constantly churn. That's ok. But ideally you are finding parts of your work which can be sent in the opposite direction: towards God; or the oneness of all things.<p>If none of your work ever seems to find a path towards simplicity and oneness, it's possible you are pathologically mixing concerns, which, if true, is probably slowing you down.
Offtopic, but the mention of elegant lightsabers reminds me of a scene from one of my favourite TV series, StarGate SG-1:<p><a href="https://www.youtube.com/watch?v=NjlCVW_ouL8" rel="nofollow">https://www.youtube.com/watch?v=NjlCVW_ouL8</a><p>Money quote at 02:25:<p><pre><code> [O'Neill demonstrating a staff weapon]
This is a weapon of terror. It's made to... intimidate the enemy.
THIS...
[O'Neill shows a P-90]
... is a weapon of _war_. It's made to _kill_ your enemy.
</code></pre>
I.e. effective beats elegant :).