Creating indices will lock the table for writes

• [?] Check for the docs

When creating indices on SQL databases like MSSQL and Postgres creating these will lock the database table. This might be warranted but should be carefully considered while having write-heavy and/or big tables.

In Postgres you can use the CONCURRENT option to still allow this.

Lukas, from a PR review

Creating indexes will lock the table for writes (if not using CONCURRENT option in Postgres). If you table is big, you might want to avoid this, especially for write-heavy tables.