Re: Vacuum freeze help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben Kammer <b_a_kammer(at)yahoo(dot)co(dot)uk>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Vacuum freeze help
Date: 2016-08-30 12:30:35
Message-ID: 22971.1472560235@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ben Kammer <b_a_kammer(at)yahoo(dot)co(dot)uk> writes:
> I have a postgresql 9.5.4 cluster and was testing with vacuum freeze. I
> expected the value of xmin to be set to '2' when I vacuum a particular
> table with the VACUUM FREEZE command.

That doesn't happen anymore; freezing just sets an info bit that indicates
that the xmin should be treated as old.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Patrick B 2016-08-30 21:51:37 Re: Rackspace to RDS - PostgreSQL 9.2 Migration Plan
Previous Message Ben Kammer 2016-08-30 12:09:37 Vacuum freeze help