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