Re: Avoiding Refreezing XIDs Repeatedly

From: bkrug <bkrug(at)usatech(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Avoiding Refreezing XIDs Repeatedly
Date: 2015-02-09 19:07:05
Message-ID: 1423508825585-5837251.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2015-02-09 19:10:35 Re: Avoiding Refreezing XIDs Repeatedly
Previous Message Matheus de Oliveira 2015-02-09 18:56:04 Re: Avoiding Refreezing XIDs Repeatedly