Re: Status of 8.3 patches - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Status of 8.3 patches
Date
Msg-id 46C9FA61.5060509@enterprisedb.com
Whole thread Raw
In response to Re: Status of 8.3 patches  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Status of 8.3 patches  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Problem with locks
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Status of 8.3 patches