Re: insert waits for delete with trigger - Mailing list pgsql-performance

From Tom Lane
Subject Re: insert waits for delete with trigger
Date
Msg-id 24197.1092112893@sss.pgh.pa.us
Whole thread Raw
In response to Re: insert waits for delete with trigger  (Litao Wu <litaowu@yahoo.com>)
Responses Re: insert waits for delete with trigger  (Litao Wu <litaowu@yahoo.com>)
List pgsql-performance
Litao Wu <litaowu@yahoo.com> writes:
> Did I miss something?

Your join omits all transaction locks.

            regards, tom lane

pgsql-performance by date:

Previous
From: Litao Wu
Date:
Subject: Re: insert waits for delete with trigger
Next
From: Bill Montgomery
Date:
Subject: Column order performance