Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3 - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3
Date
Msg-id 414A1296.2020702@bigfoot.com
Whole thread Raw
In response to Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-admin
R. Willmington wrote:> Gaetano Mendola <mendola@bigfoot.com> wrote in message
news:<41484EA5.9060904@bigfoot.com>...>>>>Areyou 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
connectionswith the command you suggested, they> are all in status "idle".>> Update on the problem described in my
initialposting:>> I have deleted some 4000 records from the table on the live system in> the meantime, it took about 36
minutesto complete. 

Do you have cascade delete ? 4000 record in 36 minutes are too much, in my
system I delete milion records in a few seconds, are you sure you are presenting
the entire scenario ?



Regards
Gaetano Mendola




pgsql-admin by date:

Previous
From: "Bender, Cheryl"
Date:
Subject: windows docs?
Next
From: "Maximiliano Araujo Pedatella"
Date:
Subject: Revoke owner's privilege on the table