Re: insert waits for delete with trigger

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: insert waits for delete with trigger
Дата
Msg-id 29338.1092156790@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: insert waits for delete with trigger  (Litao Wu <litaowu@yahoo.com>)
Список pgsql-performance
Litao Wu <litaowu@yahoo.com> writes:
> How about:

> select c.relname, l.pid, l.mode, l.granted,
> a.current_query
> from pg_locks l, pg_class c, pg_stat_activity a
> where
>   l.relation = c.oid
>   AND l.pid =  a.procpid
> order by l.granted, l.pid;

You can't join to pg_class without eliminating the transaction lock rows
(because they have NULLs in the relation field).

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [HACKERS] fsync vs open_sync
Следующее
От: "Jason Coene"
Дата:
Сообщение: Re: Hardware upgrade for a high-traffic database