Re: CommitDelay performance improvement

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: CommitDelay performance improvement
Дата
Msg-id 200102232337.SAA05517@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: CommitDelay performance improvement  (ncm@zembu.com (Nathan Myers))
Ответы Re: CommitDelay performance improvement  (ncm@zembu.com (Nathan Myers))
Список pgsql-hackers
> When thinking about tuning N, I like to consider what are the interesting 
> possible values for N:
> 
>   0: Ignore any other potential committers.
>   1: The minimum possible responsiveness to other committers.
>   5: Tom's guess for what might be a good choice.
>   10: Harry's guess.
>   ~0: Always delay.
> 
> I would rather release with N=1 than with 0, because it actually responds 
> to conditions.  What N might best be, >1, probably varies on a lot of 
> hard-to-guess parameters.
> 
> 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 becuase it has better tuning oportunities for
later releases.  What we can do is give people parameters where the
default is safe, and they can play and report to us.

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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: ncm@zembu.com (Nathan Myers)
Дата:
Сообщение: Re: CommitDelay performance improvement
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: CommitDelay performance improvement