From: | "Sahagian, David" <david(dot)sahagian(at)emc(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | ATET, could it be made "more concurrent" ? |
Date: | 2013-02-01 17:50:48 |
Message-ID: | F3CBFBA88397EA498B22A05FFA9EC49D0109E60C99@MX22A.corp.emc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 seconds)
I understand that [postgresql.org/docs/9.1/static/explicit-locking.html] tells 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-
From | Date | Subject | |
---|---|---|---|
Next Message | Leonardo M. Ramé | 2013-02-01 19:34:39 | Re: Parsing COPY ... WITH BINARY |
Previous Message | Carlo Stonebanks | 2013-02-01 16:24:09 | Re: Deleting 173000 records takes forever, blocks async queries for unrelated records |