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 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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
