On Sun, Apr 7, 2019 at 2:31 AM Pavel Suderevsky <psuderevsky@gmail.com> wrote: > Probably if you advise me what could cause "pg_serial": apparent wraparound messages I would have more chances to handle all the performance issues.
Did you see that warning at some point before the later error?
Thomas,
Thank you for your reply!
No, there have never been such warnings.
I wonder if this condition required you to have a serializable transaction running (or prepared) while you consume 2^30 AKA ~1 billion xids. I think it is unreachable in v11+ because commit e5eb4fa8 allowed for more SLRU pages to avoid this artificially early wrap.
Do I understand right that this is about Virtual txids? Have no idea how even a something close to a billion of transaction ids could be consumed on this system.