Re: Per-table freeze limit proposal - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Per-table freeze limit proposal
Date
Msg-id 15865.1126812656@sss.pgh.pa.us
Whole thread Raw
In response to Re: Per-table freeze limit proposal  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Cool.  I wonder if the exact figure should be
> min(lowest non-frozen Xid in table, GetOldestXmin(false))

Actually just min(lowest Xid in table, RecentXmin).  You only need to be
sure there are no running transactions older than what you put into the
field; their xmins are not at issue.

> Also, in light of this, it seems a bad idea to use the name "freezexid"
> for the pg_class column; I would name it relminxid or something like
> that (suggestions welcome).

Works for me.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pg_autovacuum settings not saved on dump
Next
From: Tom Lane
Date:
Subject: Re: pg_autovacuum settings not saved on dump