view the remining # of TX ID's available per db (before TX ID wraparound failure)
От | Kevin Kempter |
---|---|
Тема | view the remining # of TX ID's available per db (before TX ID wraparound failure) |
Дата | |
Msg-id | 200906231006.45363.kevink@consistentstate.com обсуждение исходный текст |
Список | pgadmin-support |
<br /> Hi all;<br /><br /><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;-qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br />I want to be sure we know exactly how closewe are to a tx id wraparound failure.<br /><br /><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px;margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br />I ranthis:<br /><br /> select datname, age(datfrozenxid) from pg_database;<br /><br /><p style="-qt-paragraph-type:empty; margin-top:0px;margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br/>I assume the resulting value is the number of available tx id's left per db, is this correct?<br/><br /><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;-qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br />Also is there a way in 8.3 to determine whichtables need to be vacuum'ed so PostgreSQL can reset the tx id values?<br /><br /><p style="-qt-paragraph-type:empty;margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br /><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px;margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br /><p style="-qt-paragraph-type:empty;margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br />Thanks in advance...<br /><br /><p style="-qt-paragraph-type:empty;margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br />
В списке pgadmin-support по дате отправления: