Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > In researching, I found we already do this by updating PGPROC.xid for
> > every command in non-serialzable transactions:
>
> Dunno how you arrived at that conclusion, but it's quite wrong.
Looking in the function I now see you are right:
if (serializable) MyProc->xmin = TransactionXmin = xmin;
So, can't this be improved to allow more aggressive vacuuming?
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +