Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3

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