supabase / auth / 19428985132

push

github

feat: async, concurrent index creation for users table (#2239)

Introduces an asynchronous index worker for creating database indexes in
the background.

- Creates indexes only when
`GOTRUE_INDEX_WORKER_ENSURE_USER_SEARCH_INDEXES_EXIST` is enabled
- Config watcher notifies the worker when the config has changed to
decide whether to create the indexes or not
- Non-blocking index creation via `CONCURRENTLY` and async worker
- Prevents multiple processes from creating indexes simultaneously via
advisory locks
- Handles interruptions (server restarts, connection loss) or
out-of-band index manipulation by checking which indexes failed (invalid
or is not ready) or don't exist and drops/recreates them
- Idempotent: existing indexes are skipped

In the future, these index related migrations might be tracked using a
different tool (e.g.: `goose`/`golang-migrate`) as `pop` does not
support migrations without transactions which makes it unsuitable for
index creation with `CONCURRENTLY`.

ref: AUTH-892

188 of 249 new or added lines in 2 files covered. (75.5%)

14192 of 20748 relevant lines covered (68.4%)

78.06 hits per line