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
Дата:
От: A. Kretschmer
Дата:
FAQ