Date: Mon, 9 Feb 2015 16:10:35 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: bkrug <bkrug@usatech.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Avoiding Refreezing XIDs Repeatedly
Message-ID: <20150209191035.GG3391@alvh.no-ip.org>
References: <1423497516487-5837222.post@n5.nabble.com>
 <CAJghg4KAFiFnH6inJ+K7Bfef9bgGYt7E6MM3rkevqiT=Q245HQ@mail.gmail.com>
 <1423507553954-5837247.post@n5.nabble.com>
 <CAJghg4LziRUuHKhuiqLjW0fuoop6kZA_CSuqx+=ZrU7gyuwKhw@mail.gmail.com>
 <1423508825585-5837251.post@n5.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <1423508825585-5837251.post@n5.nabble.com>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

bkrug wrote:
> 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.

We have considered changing this, but it needs a concerted effort.  It's
not a simple problem.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance