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

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

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "R(dot) Willmington" <willmington(at)gmx(dot)net>
Subject: Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3
Date: 2004-09-16 22:24:22
Message-ID: 414A1296.2020702@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-admin
R. Willmington wrote:
 > 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.

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




In response to

pgsql-admin by date

Next:From: Maximiliano Araujo PedatellaDate: 2004-09-16 22:48:34
Subject: Revoke owner's privilege on the table
Previous:From: Bender, CherylDate: 2004-09-16 19:13:31
Subject: windows docs?

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