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

Reply via email to