Re: Long running query causing XID limit breach

2024-05-25 Thread David HJ
anyone know how to describe from this mailing list? On Thu, May 23, 2024 at 5:16 AM sud wrote: > Hello , > It's RDS postgres version 15.4. We suddenly saw the > "MaximumUsedTransactionIDs" reach to ~1.5billion and got alerted by team > members who mentioned the database is going to be in shutdow

Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version

2023-10-09 Thread David HJ
Hello PostgreSQL Community, I am writing to propose an alternative compilation of PostgreSQL that allows for a 256-byte identifier length limit, alongside the existing 64-byte version. *Problem:* The current limit of 63 bytes can be quite restrictive, especially for databases that use multi-byte