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 200906231005.21445.kevin@kevinkempterllc.com
обсуждение исходный текст
Список pgadmin-support
Hi all;<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 close we are to a tx
idwraparound failure.<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 ran this:<br /><br /> select datname,
age(datfrozenxid)from pg_database;<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
valueis the number of available tx id's left per db, is this correct?<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 which tables need to be vacuum'ed so PostgreSQL can
resetthe tx id values?<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 /><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 /> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Bug in SQL editor find and replace
Следующее
От: Ashesh Vashi
Дата:
Сообщение: Re: Bug in SQL editor find and replace