Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
Date: 2011-10-25 02:17:39
Message-ID: C4A1B651-62AE-43A0-8FBB-1594EEBA2BB2@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Oct 24, 2011, at 8:16 AM, Venkat Balaji <venkat(dot)balaji(at)verse(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Boreham 2011-10-25 02:37:05 Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
Previous Message David Boreham 2011-10-24 23:18:18 Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server