Skip site navigation (1) Skip section navigation (2)

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

From: willmington(at)gmx(dot)net (R(dot) Willmington)
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3
Date: 2004-09-16 08:42:40
Message-ID: e6568d.0409160042.2fc21631@posting.google.com (view raw or flat)
Thread:
Lists: pgsql-admin
Gaetano Mendola <mendola(at)bigfoot(dot)com> wrote in message news:<41484EA5(dot)9060904(at)bigfoot(dot)com>...

> 
> 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 command you suggested, they
are all in status "idle".

Update on the problem described in my initial posting:

I have deleted some 4000 records from the table on the live system in
the meantime, it took about 36 minutes to complete.
After that, i ran a Vacuum full verbose on the table. The vacuum full
removed only 25 deleted records within about 5 seconds.

Regards,

R. Willmington

In response to

Responses

pgsql-admin by date

Next:From: Tom BurnsDate: 2004-09-16 12:09:27
Subject: Re: initdb fails
Previous:From: FransDate: 2004-09-16 04:22:57
Subject: Re: initdb fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group