Hello,
I have an instance where I have a series of pl/pgsql calls, that report stat
results to a common table. When other queries try to hit the stat table
(with DML commands; SELECT, INSERT, UPDATE, DELETE etc.) they are forced to
wait in a queue until the pl/pgsql has finished executing.
will:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
before these DML queries eliminate the locking?
--
marcus whitney
chief architect : cold feet creative
www.coldfeetcreative.com
800.595.4401
cold feet presents emma
email marketing for discriminating
organizations everywhere
visit www.myemma.com