I must have missed this, I did not immediately realize there was a
difference between select and delete
Thanks for the explanation and outlook.
Stefan
On Sun, 10 Mar 2019 at 10:20, wrote:
> I noticed that a delete on a table with many partitions seems to be
> using a lot of ram.
> Is this a known behaviour or related to my setup?
Yeah, It's known. There's a warning against what you're doing in
https://www.postgresql.org/docs/10/ddl-partitionin
Hi,
I noticed that a delete on a table with many partitions seems to be
using a lot of ram.
It seems to occur during the planing phase, as explain behaves the same
as the actual execution of the delete.
On the simplified test below for 4000 partitions it seems to be using
for a short time o
