Re: Recalculating OldestXmin in a long-running vacuum

Heikki Linnakangas wrote:
> Tom Lane wrote:
> > Heikki Linnakangas <heikki(at)enterprisedb(dot)com> writes:
> >> Bruce Momjian wrote:
> >>> So are you stopping work on the patch? I assume so.
> >
> >> Yes, at least for now. I can't believe the patch actually hurts
> >> performance, but I'm not going to spend time investigating it.
> >
> > Are we withdrawing the patch from consideration for 8.3 then?
> > I had assumed it was still a live candidate, but if it seems to
> > lose in pgbench maybe we had better set it aside.
>
> I haven't tried pgbench, the tests I ran were with DBT-2.
>
> Just to summarize again: the patch did help to keep the stock table
> smaller, but the response times were higher with the patch.
>
> Maybe we should keep this issue open until we resolve the vacuum WAL
> flush issue? I can then rerun the same tests to see if this patch is a
> win after that.

Would you like to add a TODO item?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +