R. Willmington wrote:
Additional information: The applications using the database are java - based and create persistent connections (from a connection pool) to the postgres database. These connections are on autocommit, thus, there should not be any opened transactions preventing the vacuum full from write - locking the tables.
Any idea what i am doing wrong? Any help appreciated.
Are you sure you dont have connection in status: "idle in transaction"? Check with:
ps -eafwww | grep post
Gaetano
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html