Re: [PATCHES] WAL logging freezing

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Heikki Linnakangas <heikki(at)enterprisedb(dot)com> writes:
> I got another idea. If we make sure that vacuum removes any aborted xid 
> older than OldestXmin from the table, we can safely assume that any xid 
> < the current clog truncation point we are going to be interested in is 
> committed. Vacuum already removes any tuple with an aborted xmin. If we 
> also set any aborted xmax (and xvac) to InvalidXid, and WAL logged that, 

The problem with that is all the extra WAL log volume it creates.  I'm
also concerned about the loss of forensic information --- xmax values
are frequently useful for inferring what's been going on in a database.
(This is another reason for not wanting a very short freeze interval BTW.)

			regards, tom lane