On Nov 4, 2007, at 6:33 PM, Greg Smith wrote:
For those of you considering a move to the upcoming 8.3 release,
now in beta, I've written some documentation on the changes made in
checkpoint and background writer configuration in the new version:
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm
Since the first half of that covers the current behavior in 8.1 and
8.2, those sections may be helpful if you'd like to know more about
checkpoint slowdowns and ways to resolve them even if you have no
plans to evaluate 8.3 yet. I'd certainly encourage anyone who can
run the 8.3 beta to consider adding some tests in this area while
there's still time to correct any issues encountered before the
official release.
Greg, thanks a lot of this. I'd say this should definitely be linked
to from the main site's techdocs section.
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster