Re: Trouble understanding how to avoid/manage ERROR: multixact "members" limit exceeded

2024-08-09 Thread Adrian Klaver
On 8/9/24 03:26, Jim Vanns wrote: Hi pggen community! I am struggling with this error almost daily now and despite various efforts, not succeeding in avoiding or dealing with it; My questions are; 1) How should I be managing this? Although not new to PG, I am new to this particular problem

Re: Trouble understanding how to avoid/manage ERROR: multixact "members" limit exceeded

2024-08-09 Thread Jim Vanns
To clear up any confusion, I tried the reductions as hinted in the error message and after a few iterations still faced the same error. Also, re. the sample configuration I provided - this is the result of said iterations after initially using the stock values from the PGDG RPM. Jim On Fri, 9 Aug

Trouble understanding how to avoid/manage ERROR: multixact "members" limit exceeded

2024-08-09 Thread Jim Vanns
Hi pggen community! I am struggling with this error almost daily now and despite various efforts, not succeeding in avoiding or dealing with it; ERROR: multixact "members" limit exceeded DETAIL: This command would create a multixact with 2 members, but the remaining space is only enough for 0 m