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

Re: CommitDelay performance improvement

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CommitDelay performance improvement
Date: 2001-02-24 02:05:20
Message-ID: 200102240205.VAA12697@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> > > It seems to me that comparing various choices (and other, more
> > > interesting, algorithms) to the N=1 case would be more productive
> > > than comparing them to the N=0 case, so releasing at N=1 would yield
> > > better statistics for actually tuning in 7.2.
> >
> > We don't release code because it has better tuning opportunities for
> > later releases. What we can do is give people parameters where the
> > default is safe, and they can play and report to us.
> 
> Perhaps I misunderstood.  I had perceived N=1 as a conservative choice
> that was nevertheless preferable to N=0.

I think zero delay is the conservative choice at this point, unless we
hear otherwise from testers.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-hackers by date

Next:From: Lincoln YeohDate: 2001-02-24 02:22:08
Subject: Re: RE: Re: [ADMIN] v7.1b4 bad performance
Previous:From: Nathan MyersDate: 2001-02-24 01:20:46
Subject: Re: CommitDelay performance improvement

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