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

From Venkat Balaji
Subject Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
Date
Msg-id CAFrxt0ggkMiqw=ZUuUN0G9aU5uzCVCkKYkD2DiLJKDd3-gaKdA@mail.gmail.com
Whole thread Raw
In response to Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
Oh yes.

Thanks a lot Robert !

Regards
VB

On Tue, Oct 25, 2011 at 7:47 AM, Robert Haas <robertmhaas@gmail.com> wrote:
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: alan
Date:
Subject: Re: delete/recreate indexes