Deadlocks...

Поиск
Список
Период
Сортировка
От postgres@countup.de
Тема Deadlocks...
Дата
Msg-id 20040314214341.BA6D35A816F@kserver17.erfurt12.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Aaron Werman"
Дата:
Сообщение: Re: Scaling further up
Следующее
От: Arjen van der Meijden
Дата:
Сообщение: Re: Large CASE-statement is pretty slow?