transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
От
Michal Szymanski
Тема
transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
Дата
Msg-id
b583dae1-cb3a-440a-9e4f-34ce25c715ee@b15g2000yqd.googlegroups.com
Список
Дерево обсуждения
transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ? Michal Szymanski <dyrex@poczta.onet.pl>
Re: transaction ID wraparound - should I use 'VACUUM'
or 'VACUUM FULL' ? Alvaro Herrera <alvherre@commandprompt.com>
Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ? Tom Lane <tgl@sss.pgh.pa.us>
Hi, In old version of Postgres we have to execute 'VACUUM FULL' to solve problem of transaction ID wraparound, do we need to execute 'VACUUM FULL' in Postgres 8.3 or 8.4 to avoid this problem? How to check using SQL if transaction ID is close to wraparound? Michal Szymanski http://blog.szymanskich.net
В списке pgsql-general по дате отправления
