Re: Force removing Locks
От
Tom Lane
Тема
Re: Force removing Locks
Дата
Msg-id
1999.1215702361@sss.pgh.pa.us
Ответ на
Force removing Locks (Florian Eberle)
Список
Дерево обсуждения
Force removing Locks Florian Eberle <florian.eberle@gmail.com>
Re: Force removing Locks Tom Lane <tgl@sss.pgh.pa.us>
Florian Eberle writes: > I've got a Problem... An Application that uses my Postgres Server always > keeps some locks open... Is there a Possibility to forcing remove the > Locks after a certain Interval or to remove them by hand? Fix your application to close its transaction occasionally. Leaving a transaction open forever prevents vacuum from cleaning dead rows, quite independently of any locking issues. regards, tom lane
В списке pgsql-general по дате отправления
От: Ivan Sergio Borgonovo
Дата: