Re: DELETE takes too much memory

On 07/04/2016 10:10 AM, Kouber Saparev wrote:
> No. There are AFTER triggers on other tables that write to this one
> though. It is an audits table, so I omitted all the foreign keys on purpose.

Is it possible that the DELETE blocked many of those triggers due to
locking the same rows?

Incidentally, any time I get into deleting large numbers of rows, I
generally find it faster to rebuild the table instead ...

--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)