Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate