ubject: Re: ERROR: invalid memory alloc request size when committing
transaction
On Thu, 12 Aug 2021 at 06:42, Michael Harris
wrote:
>
> Thanks Tom,
>
> > How many is "a large number"?
>
> 377k approx.
I'm going to guess that it is the invalidation messag
On Thu, 12 Aug 2021 at 06:42, Michael Harris
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 t
PM
To: Michael Harris
Cc: 'pgsql-general@lists.postgresql.org'
Subject: Re: ERROR: invalid memory alloc request size when committing
transaction
Michael Harris writes:
> - Next we run a migration script on each database in the cluster. The
> migration script
> con
Michael Harris writes:
> - Next we run a migration script on each database in the cluster. The
> migration script
> converts a large number of tables from inheritance based partitioning to
> declarative
> partitioning. Unfortunately I am not at liberty to share the migration
> script
