Postgres Pro
Downloads
Home   >   mailing lists

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 22223.1092097903@sss.pgh.pa.us
Whole thread Raw
In response to insert waits for delete with trigger  (Litao Wu <litaowu@yahoo.com>)
Responses Re: insert waits for delete with trigger
List pgsql-performance
Tree view 
Litao Wu <litaowu@yahoo.com> writes:
> Here is info from pg_lock:

All those locks are already granted, so they are not much help in
understanding what PID 18951 is waiting for.  What row does it have
with granted = 'f' ?

            regards, tom lane

pgsql-performance by date:

Previous
From: Litao Wu
Date:
Subject: insert waits for delete with trigger
Next
From: Litao Wu
Date:
Subject: Re: insert waits for delete with trigger