Deadlocks... - Mailing list pgsql-performance

From postgres@countup.de
Subject Deadlocks...
Date
Msg-id 20040314214341.BA6D35A816F@kserver17.erfurt12.de
Whole thread Raw
List pgsql-performance
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 

pgsql-performance by date:

Previous
From: "Aaron Werman"
Date:
Subject: Re: Scaling further up
Next
From: Arjen van der Meijden
Date:
Subject: Re: Large CASE-statement is pretty slow?