I think 50 is a bit higher.
Greg,
Sure. I would collect the info from pg_stat_bgwriter on regular intervals.
As we have too many transactions going on I am thinking to collect the info every 6 or 8 hrs.
Thanks
VB
On Wed, Oct 5, 2011 at 4:02 AM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote:
On 10/04/2011 03:50 AM, Venkat Balaji wrote:Try saving it like this instead:
I had a look at the pg_stat_bgwriter as well.
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.
--
Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
