I have a table "aaa" which is not very big. It has less than 10'000 rows. However read operations on this table is very frequent.
Whenever I try to create a new table "bbb" with foreign key pointing to "aaa". The operation locks, and reading "aaa" is not possible. The query also never seems to finish.