Rajarshi Guha <rguha@xxxxxxxxxxx> writes: > On Thu, 2006-08-24 at 10:50 -0400, Tom Lane wrote: >> I think you are getting burnt by the list of pending trigger actions >> to check the foreign-key references in B. > Thanks for the pointer. I've dropped the constraint and am now running > the INSERT. > However when I look at the output of top, I'm seeing that the %MEM value > is continuously increasing and I'm worried that I'm going to hit the > same problem in a few hours. Sure you got all the FK constraints involving table B? Do you have any AFTER triggers other than the FK constraints? > One thing I did not mention previously is that table A has some > constraints on some fields (notably field b is specified to be NOT > NULL). Plain old CHECK constraints shouldn't matter. Tell us more about those functions in the SELECT though --- what are they? regards, tom lane
