Re: [GENERAL] Cannot Delete

[Tim McAuley]

Not sure about 2.5 million records but try running "VACUUM ANALYSE" 
before the delete and during (every now and then).

Had the same problem with 100,000 records and it did the trick nicely.

Hi,
hi have a table with 2.5 million records which i try do delete. i have 
several constraints on it too.
i tried to delete the records using delete but it does not seem to 
work. the delete runs forever. hrs...
i cannot truncate it as it complains about foreign keys.

What is the problem ?

Thanks
Alex


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])