Re: Status of 8.3 patches

Joshua D. Drake wrote:
> Heikki Linnakangas wrote:
>> Bruce Momjian wrote:
>>>   o  Automatic adjustment of bgwriter_lru_maxpages 
>>>
>>>      We show this as waiting for performance results.  I am thinking we
>>>      should hold this for 8.4.
>> Agreed. I spent close to a week trying different benchmarks and
>> configurations and simple test cases on a test server and my laptop, and
>> couldn't demonstrate bgwriter making a positive impact in any
>> configuration I tried. The theory behind the patch is sound, but it
>> looks like a lot more testing and analysis is needed.
> 
> Wouldn't real world testing be needed to actually gain insight to this
> patch?

I would expect a fairly static benchmark workload to benefit from having
a bgwriter, more so than more unpredictable real world applications.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com