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

2004-09-18 Thread R. Willmington
Gaetano Mendola <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > > Are you sure you dont have connection in status: "idle in transaction"? > Check with: > > ps -eafwww | grep post > > > Gaetano Hello Gaetano, Thank you for the reply. I have checked the connections with the

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

2004-09-16 Thread Gaetano Mendola
R. Willmington wrote: > Gaetano Mendola <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > > >>Are you sure you dont have connection in status: "idle in transaction"? >>Check with: >> >>ps -eafwww | grep post >> >> >>Gaetano > > > Hello Gaetano, > > Thank you for the reply. > I have

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

2004-09-15 Thread Gaetano Mendola
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