Table A Field 1 has a foreign key relationship with Table B Field 2. When I do an Insert into Table A, Postgres seems to be taking an exclusive lock on the record in Table B where Field 2 matches Field 1 in Table A (until the Insert is committed). This doesn't make sense to me. Can someone help me understand this? This lock is causing major throughput problems.
Thanks,
Pat
Patrick T. Donahue
(256) 544-5943 (office)
(256) 721-0726 (home)
4607 Old Railroad Bed Road
Harvest, AL 35749