DELETE takes too much memory

From: Kouber Saparev <kouber(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: DELETE takes too much memory
Date: 2016-07-04 16:35:47
Message-ID: CAN4RuQtCYxQg0u_NUncLAyLE-Yd9Yv1Ont5R2skJ53Xygvc4Xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I tried to DELETE about 7 million rows at once, and the query went up to
15% of the RAM (120 GB in total), which pushed some indexes out and the
server load went up to 250, so I had to kill the query.

The involved table does not have neither foreign keys referring to other
tables, nor other tables refer to it. The size of the table itself is 19 GB
(15% of 120 GB). So why the DELETE tried to put the entire table in memory,
or what did it do to take so much memory?

I am using 9.4.5.

Regards,
--
Kouber Saparev

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2016-07-04 17:04:58 Re: DELETE takes too much memory
Previous Message Vladimir Borodin 2016-07-04 13:30:51 Re: [HACKERS] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6