Hi all, I have a question about xid wraparound. The document below say that warning occurs when transactionId which I can use is reduced to less than 11,000,000. https://www.postgresql.org/docs/11/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND ============================== If for some reason autovacuum fails to clear old XIDs from a table, the system will begin to emit warning messages like this when the database's oldest XIDs reach ten million transactions from the wraparound point: WARNING: database "mydb" must be vacuumed within 177009986 transactions HINT: To avoid a database shutdown, execute a database-wide VACUUM in "mydb". ============================== But example message of document wrote "within 177009986 transactions". What case do I can show transaction over 11,000,000 ? Best regards, -- Takuma Hoshiai <hoshiai@xxxxxxxxxxxx>
