Re: Force removing Locks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Force removing Locks
Дата
Msg-id 1999.1215702361@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Force removing Locks  (Florian Eberle <florian.eberle@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Florian Eberle <florian.eberle@gmail.com> 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
Дата:
Сообщение: Re: expected O^2 looks line K^O, index problem not involved: [was] looping simpler query just faster
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: SPACE FOR POSTGRESQL DATABASE