Re: Force removing Locks - Mailing list pgsql-general

From Tom Lane
Subject Re: Force removing Locks
Date
Msg-id 1999.1215702361@sss.pgh.pa.us
Whole thread Raw
In response to Force removing Locks  (Florian Eberle <florian.eberle@gmail.com>)
List 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 by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: expected O^2 looks line K^O, index problem not involved: [was] looping simpler query just faster
Next
From: "A. Kretschmer"
Date:
Subject: Re: SPACE FOR POSTGRESQL DATABASE