| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Per-table freeze limit proposal |
| Date: | 2005-09-15 19:30:56 |
| Message-ID: | 15865.1126812656@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-09-15 19:41:27 | pg_autovacuum settings not saved on dump |
| Previous Message | Alvaro Herrera | 2005-09-15 19:21:34 | Re: Per-table freeze limit proposal |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-09-16 01:08:28 | Re: sum(int4)/sum(int2) improvement |
| Previous Message | Alvaro Herrera | 2005-09-15 19:21:34 | Re: Per-table freeze limit proposal |