I have a rather small database(200Mb) which was running on ubuntu 10.10/amazon ec2 fine for a year almost but today I ran into the following problem: When I create a table that references other table like:
CREATE TABLE "limit" ( "id" serial NOT NULL PRIMARY KEY, "currency_id" integer NOT NULL UNIQUE REFERENCES "currency" ("id") DEFERRABLE INITIALLY DEFERRED, "min_amount" numeric(10, 2) NOT NULL, "max_amount" numeric(10, 2) NOT NULL )
The thread hangs and blocks all other threads eventually,(but I can still terminate it with kill -INT) though the other table (currency) is rather small like 24 entries. Sources out there say that I should reindex my table but then again, running
REINDEX table currency
hangs forever. BTW creating the table without index, works like a charm. What can be the possible explanation and solution to this?