Re: Basic question regarding insert

On 10/31/2014 3:24 AM, Anil Menon wrote:

I have a very basic question on inserts - I tried to get a good authoritative answer but could not really find one to my satisfaction in the usual places.

TLDR : can (after) insert trigger be run in parallel?

the trigger is run in the context of the connection and transaction that invoked it.    the original INSERT doesn't return til any and all triggers are processed.   OTHER connections can do concurrent inserts to the same tables, as long as you're not using explicit table locks.

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast