Re: DELETE takes too much memory

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Kouber Saparev <kouber(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: DELETE takes too much memory
Date: 2016-07-05 18:51:54
Message-ID: 577C01CA.6080208@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mkrtchyan, Tigran 2016-07-05 19:17:33 Re: Tuning guidelines for server with 256GB of RAM and SSDs?
Previous Message trafdev 2016-07-05 15:35:56 Re: less than 2 sec for response - possible?