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
