Hi Tom,
No row has granted='f'.
The result shown in the original email is from:
select c.relname, l.pid, l.mode, l.granted,
current_query
from pg_locks l, pg_class c, pg_stat_activity a
where relation is not null
AND l.relation = c.oid
AND l.pid = a.procpid
AND l.mode != 'AccessShareLock'
order by l.pid;
After the above result, I went to OS
to get ps status.
Did I miss something?
Since the lock was granted to pid (18951), that
cause me confuse why OS ps shows it is waiting.
Also, I ntoiced that insert will be finished
almost immediately after delete is done.
Thanks,
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
> settings
>
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
