Re: What is the most optimal config parameters to keep stable write TPS ?..

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: What is the most optimal config parameters to keep stable write TPS ?..
Date: 2009-05-12 02:38:38
Message-ID: dcc563d10905111938g2723b375ief8812412057947a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, May 11, 2009 at 8:15 PM, Greg Smith <gsmith(at)gregsmith(dot)com> wrote:

> http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm is a long
> discussion of just this topic, if you saw a serious change by adjusting
> checkpoint_timeout than further experimentation in this area is likely to
> help you out.

I highly recommend your article on the background writer. Reading the
one on tuning the 8.2 bgw allowed me to make some changes to the
production servers at my last job that made a huge difference in
sustained tps on a logging server

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2009-05-12 05:11:40 Re: Any better plan for this query?..
Previous Message Greg Smith 2009-05-12 02:15:32 Re: What is the most optimal config parameters to keep stable write TPS ?..