From: | Takuma Hoshiai <hoshiai(at)sraoss(dot)co(dot)jp> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | what case does xid wraparound warning messages like example emit? |
Date: | 2019-03-29 07:27:24 |
Message-ID: | 20190329162724.644e3e12ec6ce7f16d95e5f8@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sraoss(dot)co(dot)jp>
From | Date | Subject | |
---|---|---|---|
Next Message | Vadi | 2019-03-29 09:44:24 | PostgreSQL equivalent of Oracle "member of" |
Previous Message | Andreas Kretschmer | 2019-03-29 05:42:52 | Re: Archival process of partition tables with filtering few rows from tables. |