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