Greg Williamson <gwilliamson39@xxxxxxxxx> writes: > I've got a fairly large table (186 million rows) that is moderately busy ( a few inserts per second at most) that I am trying to create a trigger on -- it is just hanging. CREATE TRIGGER per se is pretty quick ... but it requires an exclusive lock on the table. Most likely your problem is that it's backed up behind existing holders of locks. The pg_locks view should help you figure out what's blocking it. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
