Re: Avoiding Refreezing XIDs Repeatedly - Mailing list pgsql-performance

From bkrug
Subject Re: Avoiding Refreezing XIDs Repeatedly
Date
Msg-id 1423508825585-5837251.post@n5.nabble.com
Whole thread Raw
In response to Re: Avoiding Refreezing XIDs Repeatedly  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Responses Re: Avoiding Refreezing XIDs Repeatedly
List 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 by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: Avoiding Refreezing XIDs Repeatedly
Next
From: Alvaro Herrera
Date:
Subject: Re: Avoiding Refreezing XIDs Repeatedly