On Sat, 27 Oct 2001, Sheer El-Showk wrote:
> I tried disabling foreign keys to test this and I didn't see a real
> performance increase. Does setting pgenable in the pg_trigger table to
> false disable all the foreign keys?
I don't believe so. I think the only real ways to do that are to delete
them or temporarily set reltriggers to 0 in the pg_class for those tables.
> Is there any way to get a good trace of the locks or lock contention?
There probably is, but I don't know of one.