Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter - Mailing list pgsql-performance

From Robert Haas
Subject Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
Date
Msg-id C4A1B651-62AE-43A0-8FBB-1594EEBA2BB2@gmail.com
Whole thread Raw
In response to Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter  (Venkat Balaji <venkat.balaji@verse.in>)
Responses Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter  (Venkat Balaji <venkat.balaji@verse.in>)
List pgsql-performance
On Oct 24, 2011, at 8:16 AM, Venkat Balaji <venkat.balaji@verse.in> wrote:
> Thanks Greg !
>
> Sorry for delayed response.
>
> We are actually waiting to change the checkpoint_segments in our production systems (waiting for the downtime).

That setting can be changed without downtime.

...Robert

pgsql-performance by date:

Previous
From: David Boreham
Date:
Subject: Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
Next
From: David Boreham
Date:
Subject: Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server