search

kaaveland / eugene

Careful With that Lock, Eugene
MIT License
32 stars 1 forks source link

Add hint for`create index ... concurrently` #20

Closed kaaveland closed 7 months ago

kaaveland commented 7 months ago

create index ... blocks writes to the table, and create index ... concurrently is a safe variation. We could match this against the sql statement string, or the lock taken, or by finding indexes only visible in our transaction (we'd see a new pg_class row of relkind 'i').

kaaveland commented 7 months ago

Solved in https://github.com/kaaveland/eugene/pull/31.