Re: Avoiding Refreezing XIDs Repeatedly

Поиск
Список
Период
Сортировка
От bkrug
Тема Re: Avoiding Refreezing XIDs Repeatedly
Дата
Msg-id 1423508825585-5837251.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: Avoiding Refreezing XIDs Repeatedly  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Ответы Re: Avoiding Refreezing XIDs Repeatedly  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-performance
The problem I'm facing is that I have many large (several GB) tables that are
not being changed (they are several days old) but auto-vacuum keeps scanning
and updating them every time the xid wraps around and thus my rsync back-up
process sees that the disk files have changed and must copy them.



--
View this message in context: http://postgresql.nabble.com/Avoiding-Refreezing-XIDs-Repeatedly-tp5837222p5837251.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


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

Предыдущее
От: Matheus de Oliveira
Дата:
Сообщение: Re: Avoiding Refreezing XIDs Repeatedly
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Avoiding Refreezing XIDs Repeatedly