Skip site navigation (1) Skip section navigation (2)

Re: Recalculating OldestXmin in a long-running vacuum

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org, Gregory Stark <gsstark(at)mit(dot)edu>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Subject: Re: Recalculating OldestXmin in a long-running vacuum
Date: 2007-03-27 17:15:43
Message-ID: 200703271715.l2RHFhC07074@momjian.us (view raw or flat)
Thread:
Lists: pgsql-patches
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. +

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2007-03-27 17:19:25
Subject: Re: Recalculating OldestXmin in a long-running vacuum
Previous:From: Heikki LinnakangasDate: 2007-03-27 17:10:05
Subject: Re: Recalculating OldestXmin in a long-running vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group