On Tue, Oct 4, 2011 at 4:32 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote: > On 10/04/2011 03:50 AM, Venkat Balaji wrote: >> >> I had a look at the pg_stat_bgwriter as well. > > Try saving it like this instead: > > select now(),* from pg_stat_bgwriter; > > And collect two data points, space a day or more apart. That gives a lot > more information about the rate at which things are actually happening. The > long-term totals are less interesting than that. > > Generally the first round of tuning work here is to increase > checkpoint_segments until most checkpoints appear in checkpoints_timed > rather than checkpoints_req. After that, increasing checkpoint_timeout > might also be useful. That last paragraph should be printed out and posted on every pgsql admin's cubicle wall. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
