Re: Migrating to 8.3 - checkpoints and background writer

From: Erik Jones <erik(at)myemma(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Migrating to 8.3 - checkpoints and background writer
Date: 2007-11-05 16:54:05
Message-ID: 260AB514-77C4-485F-847B-7D76E77D2C0D@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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(at)myemma(dot)com
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Hoover 2007-11-05 18:43:07 Which index methodology is better?-
Previous Message Campbell, Lance 2007-11-05 16:44:04 Training Recommendations