Re: Recalculating OldestXmin in a long-running vacuum - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Recalculating OldestXmin in a long-running vacuum
Date
Msg-id 200703271715.l2RHFhC07074@momjian.us
Whole thread Raw
In response to Re: Recalculating OldestXmin in a long-running vacuum  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-patches
Heikki Linnakangas wrote:
> Tom Lane wrote:
> > Heikki Linnakangas <heikki@enterprisedb.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@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

pgsql-patches by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Recalculating OldestXmin in a long-running vacuum
Next
From: Tom Lane
Date:
Subject: Re: Recalculating OldestXmin in a long-running vacuum