Re: ERROR: invalid memory alloc request size when committing transaction

On Thu, 12 Aug 2021 at 06:42, Michael Harris
<michael.harris@ericsson.com> wrote:
>
> Thanks Tom,
>
> > How many is "a large number"?
>
> 377k approx.

I'm going to guess that it is the invalidation messages for all the
DDL that is causing the memory allocation error. If you set wal_level
= minimal then this might work.

The total number indicates you are using too many partitions and
should probably lower that by a factor of about 100.
If you do that, you probably won't need to set wal_level.

-- 
Simon Riggs                http://www.EnterpriseDB.com/