Re: Avoiding Refreezing XIDs Repeatedly

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: bkrug <bkrug(at)usatech(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Avoiding Refreezing XIDs Repeatedly
Date: 2015-02-09 19:10:35
Message-ID: 20150209191035.GG3391@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luis Antonio Dias de Sá Junior 2015-02-09 19:30:13 Survey: Max TPS you've ever seen
Previous Message bkrug 2015-02-09 19:07:05 Re: Avoiding Refreezing XIDs Repeatedly