Re: transactoin id wraparound problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: transactoin id wraparound problem
Дата
Msg-id 25552.1157580285@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: transactoin id wraparound problem  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-admin
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> The most common cause of these problems is that you have long standing
> transactions that never get closed.

That can cause table bloat but it shouldn't have anything to do with XID
wraparound problems.  My guess is that the vacuum attempts are failing
somewhere along the line, and that some perusal of the postmaster log
would shed light on the issue.

            regards, tom lane

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

Предыдущее
От: "Sriram Dandapani"
Дата:
Сообщение: Re: transactoin id wraparound problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: transactoin id wraparound problem