Re: Autovacuum to prevent wraparound tries to consume xid

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: Autovacuum to prevent wraparound tries to consume xid
Дата
Msg-id CAPpHfdv9YkNXWv40BpQrpOdXwgy-3ibbQu_CxUc181Hu8UZbJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Autovacuum to prevent wraparound tries to consume xid  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Список pgsql-hackers
On Mon, Mar 28, 2016 at 2:05 PM, Alexander Korotkov <a.korotkov@postgrespro.ru> wrote:
After some debugging I found that vac_truncate_clog consumes xid just to produce warning.  I wrote simple patch which replaces GetCurrentTransactionId() with ShmemVariableCache->nextXid.  That completely fixes this situation for me: ShmemVariableCache was successfully updated.

I found that direct reading of ShmemVariableCache->nextXid is not corrent, it's better to use ReadNewTransactionId() then.  Fixed version of patch is attached.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Вложения

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: foreign table batch inserts
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Parallel query