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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to