Florian Eberle <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general