Re: understand the process of ID wraparound
| От | KKreuzer@kbtoys.com |
|---|---|
| Тема | Re: understand the process of ID wraparound |
| Дата | |
| Msg-id | OF5C6D96C7.8100A3FA-ON852574D3.004DA457-852574D3.004E5E96@kbtoys.com обсуждение исходный текст |
| Ответ на | Re: understand the process of ID wraparound (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: understand the process of ID wraparound
|
| Список | pgsql-admin |
Thank you Tom..
Can you recommend any documentation that explains the process?
Keith Kreuzer
ext 3424
| Tom Lane <tgl@sss.pgh.pa.us> 09/29/2008 10:00 AM |
|
KKreuzer@kbtoys.com writes:
> I am hoping someone can help a novice understand the process of ID
> wraparound, I have read many of the articles
> on the web but don't understand why my age(datfrozenxid) never gets reset.
> I am not sure if I even have a
> problem, just trying to be proactive.
You don't have a problem. The datfrozenxid values you are showing are
around 31 million transactions. Nothing is going to happen until they
exceed vacuum_freeze_min_age, which is 100 million transactions.
regards, tom lane
В списке pgsql-admin по дате отправления: