Re: Orphan TOAST object

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Orphan TOAST object
Дата
Msg-id 18954.1210601335@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Orphan TOAST object  ("James Farrugia" <james.farrugia@gmail.com>)
Ответы Re: Orphan TOAST object  ("James Farrugia" <james.farrugia@gmail.com>)
Список pgsql-admin
"James Farrugia" <james.farrugia@gmail.com> writes:
> One last thing...can we run into data-loss problems with successfully
> vacuumed tables even if there is one unvacuumed database object; what would
> have happened if I ignored to vacuum that rogue pg_toast (which was the only
> unvacuumed object within the entire database)?

The database would have shut down when you got to the
2-billion-transactions mark.  So you'd have had to solve the problem
sooner or later anyway.

            regards, tom lane

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

Предыдущее
От: Julius Tuskenis
Дата:
Сообщение: how to get a number of seconds in some interval ?
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: how to get a number of seconds in some interval ?