Re: Final background writer cleanup for 8.3 - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Final background writer cleanup for 8.3
Date
Msg-id Pine.GSO.4.64.0709051222390.27984@westnet.com
Whole thread Raw
In response to Re: Final background writer cleanup for 8.3  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Final background writer cleanup for 8.3
List pgsql-hackers
On Tue, 4 Sep 2007, Josh Berkus wrote:

> In about 200 benchmark test runs, I don't feel like we ever came up with a
> set of bgwriter settings we'd happily recommend to others.  SO it's hard
> for me to tell whether this is true or not.

Are you talking about 200 runs with 8.2.4 or 8.3?  If you've collected a 
bunch of 8.3 data, that's something I haven't been able to do; if what 
you're saying is that you never found settings with 8.2.4 that you'd 
recommend, that's consistant with what I was saying.

> Can you send me the current version of the patch, plus some bgwriter
> settings to try with it, so we can throw it on some of the Sun benchmarks?

Am in the middle of wrapping this up today, will send out a patch for 
everyone to try shortly.  Tests are done, patch is done for now, just 
writing the results up and making my tests reproducible.  I had some 
unexpected inspiration the other day that dragged things out, but with 
useful improvements.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


pgsql-hackers by date:

Previous
From: Decibel!
Date:
Subject: Oddity with psql \d and pg_table_is_visible
Next
From: Josh Berkus
Date:
Subject: Re: Final background writer cleanup for 8.3