ATET, could it be made "more concurrent" ?

Поиск
Список
Период
Сортировка
От Sahagian, David
Тема ATET, could it be made "more concurrent" ?
Дата
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D0109E60C99@MX22A.corp.emc.com
обсуждение исходный текст
Список pgsql-general
PostgreSQL 9.1.x

I try to enable my trigger
  "ALTER TABLE cool_tbl ENABLE TRIGGER trg_for_cool_tbl;"

I notice that it gets blocked by another backend doing
  "select xxx from cool_tbl;"
(of course, my pain is if this transaction lasts for minutes, instead of se=
conds)

I understand that [postgresql.org/docs/9.1/static/explicit-locking.html] te=
lls us
The request for "AccessExclusiveLock" on relation R will be blocked by the =
existing "AccessShareLock" on relation R.

But I cannot reconcile that with . . .

How could doing ENABLE of a trigger hurt the transaction that has thus far =
only done a SELECT on the table ?

Thanks for your insight,
-dvs-

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

Предыдущее
От: "Carlo Stonebanks"
Дата:
Сообщение: Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
Следующее
От: Leonardo M. Ramé
Дата:
Сообщение: Re: Parsing COPY ... WITH BINARY