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"?
>>ps -eafwww | grep post
> 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 ?
In response to
pgsql-admin by date
|Next:||From: Maximiliano Araujo Pedatella||Date: 2004-09-16 22:48:34|
|Subject: Revoke owner's privilege on the table|
|Previous:||From: Bender, Cheryl||Date: 2004-09-16 19:13:31|
|Subject: windows docs?|