Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum freeze help - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum freeze help
Date
Msg-id 22971.1472560235@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum freeze help  (Ben Kammer <b_a_kammer@yahoo.co.uk>)
List pgsql-admin
Tree view 
Ben Kammer <b_a_kammer@yahoo.co.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

pgsql-admin by date:

Previous
From: Ben Kammer
Date:
Subject: Vacuum freeze help
Next
From: Patrick B
Date:
Subject: Re: Rackspace to RDS - PostgreSQL 9.2 Migration Plan