Thread: Deadlocks...

Deadlocks...

From
postgres@countup.de
Date:
Hi, <br /><br />i have 2 Functions, one ist called by page visitors (something about 2,000 times / 1 hour) <br />and
theother just by the admin (let say 1 time per hour or per login) <br />i often get a deadlock error after calling the
adminfunction <br />yes they try to access the same table somewhere in the function code. <br />The Admin function can
takeup to 20-30 seconds and visitor function just 20 to 30 ms <br />What can i do there? Have i to study a lot about
lockingtables or something else? <br /><br />Thanks for your Help <br />regards, <br />Boris