I need to add index to a column in a very large table.
To avoid locking the table, I tried to use CREATE INDEX CONCURRENTLY.
During the testing on a small dataset, I found that will lead the Play framework schema evolution to hang.After I removed the CONCURRENTLY, schema evolution can finish quickly.
Versions:
"com.typesafe.play" %% "play" % "2.6.15",
"com.typesafe.play" %% "play-java" % "2.6.15",