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) -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
