3 ms·
This is a pretty impressive set of new features and fixes (i.e. things that worked in Postgres, but not with CitusDB). In particular, the added ability to run
by brandur 9y ago
This is a pretty impressive set of new features and fixes (i.e. things that worked in Postgres, but not with CitusDB).
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).
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.
[1] https://www.postgresql.org/docs/current/static/sql-createindex.html https://www.postgresql.org/docs/current/static/sql-createind...