Re: Maximum xid increasing

2023-11-08 Thread Laurenz Albe
On Wed, 2023-11-08 at 09:09 -0500, Craig Milhiser wrote: > Our max xid are over 500m and climbing. Auto vacuuming and manual vacuuming  > are returning > > autovacuuming to prevent wraparound. > WARNING:  oldest xmin is far in the past > HINT:  Close open transactions soon to avoid wraparound prob

Maximum xid increasing

2023-11-08 Thread Craig Milhiser
Our max xid are over 500m and climbing. Auto vacuuming and manual vacuuming are returning autovacuuming to prevent wraparound. WARNING: oldest xmin is far in the past HINT: Close open transactions soon to avoid wraparound problems. You might also need to commit or roll back old prepared transact