Re: delete on table with many partitions uses a lot of ram

2019-03-10 Thread reg_pg_stefanz
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

Re: delete on table with many partitions uses a lot of ram

2019-03-09 Thread David Rowley
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