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 18:45:53
Message-ID: 1423507553954-5837247.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Matheus de Oliveira wrote
> It changed in recent versions (9.3 or 9.4, I don't recall exactly which)
> and moved to tuple header, but what you described is exactly what was
> done,
> the xid was 2.

Should the relfrozenxid of pg_class then equal 2 for very old and already
vacuumed tables? Because that is not what I am seeing.

--
View this message in context: http://postgresql.nabble.com/Avoiding-Refreezing-XIDs-Repeatedly-tp5837222p5837247.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 18:53:05 Re: Avoiding Refreezing XIDs Repeatedly
Previous Message David G Johnston 2015-02-09 18:17:52 Re: Migrating a FoxPro system and would like input on the best way to achieve optimal performance